InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 08:13:39 GMT20http://www.sqlservercentral.com/Forums/Topic1404773-391-1.aspx6k rows is not really not that much to look through. Full Text indexing can make that sort of thing happen pretty fast.--EDIT--Seems that Anthony was quicker on the draw here. :-PWed, 09 Jan 2013 07:26:18 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1404773-391-1.aspxUnsure what DB platform Amazon run off, but for SQL you could look at Full Text Indexing.Wed, 09 Jan 2013 07:24:13 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404773-391-1.aspxWhen I use "Search Customer Reviews" in Amazon.com, it surprises me that it only take less than half second with more than 6000 review. (e.g. review in Kindle Fire HD).Which way to make it possible?Wed, 09 Jan 2013 07:19:43 GMTadonetok