Hi! On Jul 28, Niels Larsen wrote: > Greetings, > > Do anyone know where to find a description of how fulltext indexing > and query speeds depend on data volume? I have 30-40 gb of text > distributed across 30-40 million entries, a medium size database I > suppose. But I have not even been able to test a query yet, because > indexing is on its second day. Which I think cant be right. I will come > up with the details if anyone asks, but how long is indexing supposed > to take on different amounts of data? if there is a way to predict how > long it will take, then that might work; then we may simply buy a > machine do nothing but indexing .. assuming the "boolean mode" > queries finish in "interactive time", ie seconds, not minutes. I use v. > 4.0.12, but will happily upgrade if indexing becomes faster.
About "indexing is on its second day"... How is it done ? You insert data into the table with FULLTEXT index ? Or you add an index to existing table (with ALTER TABLE or alike) ? What does SHOW PROCESSLIST shows ? Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]