09-02-2005, 09:41 PM
|
Junior Member
|
|
Join Date: Sep 2005
Posts: 5
|
|
DB Size Questions
From your site:
Quote:
tdSearch works well on a smaller sized table. The script has also been used on a table of about 100K, but at 100K the script can show a performance hit, especially when LIKE queries are allowed. For example, using a table of about 100K and 20,000 rows, searching on two letters takes about 10 seconds, searching on three letters takes about 7 seconds, and searching on four letters takes about 4 seconds. tdSearch has the option to set the number of characters to be used in LIKE queries.
|
The site that I am working on will contain rather long articles.
So far I have 36 entries and my articles table is 258.1 KB.
With your software, what search times are can I expect now and as the sight grows? Are there optimizations to the software or my db that will help? Or should I assume that tdSearch will not be a good fit due to size and the time it takes to run the query?
I am looking for as turnkey a solution as possible.
|