On Jul 28, Niels Larsen wrote:
> 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 ?
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany