Re: MS SQL Server 2000 - Search a table with 300,000+ records in less then a second or two
Posted by 1492a2001 on 10/14/05 19:48
On a Athon3200+ (32 bits) home computer
it takes 1692ms to search something like '%RRIDA%' on 393951 rows
table. The maximum length of a row is 3576 bytes. So you only need a
faster CPU and faster memory controler and enough memory to hold the
data pages in memory to achive subsecond time. But IMHO I think this
kind of search is a nonsense for this number of rows.