Re: Full-Text on double rows

[Chris Nolan]

Lorderon wrote:

If I got a full-text table with X rows, and some search takes 5 sec..
Now if I got a full-text table with 2X rows, how much time will take the
same search on twice amount of rows? Is the difference linear???
thanks in advance,
-Lorderon


 

Which version of MySQL?? The difference will be different (!!) depending 
on the version in use.

In general, full text search uses a tree-structure. Doubling the number 
of entries in the tree is likely to result in a time difference of not 
very much at all!

Best regards,

Chris

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]