09-06-2005, 12:57 AM
|
|
Administrator
|
|
Join Date: Jul 2005
Posts: 46
|
|
Quote:
|
Originally Posted by SoapinTrucker
 phpMyAdmin shows it as 13.1 meg.......................
( Data 7,699 KB, Index 5,715 KB, Total 13,414 KB)
As of a minute ago that is, and contains 22,207 rows/links!
|
Hmm, I may have mistyped 100K, but I'm not sure what I meant, as I no longer have that data. I just searched on "a or e or i or o or u" (without quotes) on Soap's spiderweb and got 4.75, 4.68, 4.78, 4.82, and 4.54 on five searches of the same. Looks like I need to take new benchmarks. 
Quote:
|
Originally Posted by SoapinTrucker
Winston, does the way a db/table get indexed help the speed? (I'm guessing it does, but the point is, HOW to make an index that speedy........mine seems to be in overdrive, it is fast! (LOL ))
|
The way content is inserted into the search table does not depend on, and I'd say (without testing indexes and such) it doesn't really affect, how tdSearch searches said table: tdSearch uses the same procedure i.e. script to search the table regardless of met hod used to insert table content.
|