Author: Claus Denk Email: [EMAIL PROTECTED] Message: Hi, I wonder why the word database is structured like it is. The "dict" table contains words and urls, but each word may show up many times. Wouldn't it be more efficient to split up this table into two tables, one that contains each word only once, and say an integer identifier, and another table which looks like "dict" now, but instead of the words contains the integer identifiers. This would at least reduce the necessary index space, and probably also would decrease search time (searches in integer index should be faster). The search would then be in two stages: first find words that meet search and then do search with integer identifiers. We have a 300 Megabyte database right now, and an exact word match search takes 4-5 seconds, which seems quite slow to me. Is there any configuration option which would allow me to optimize searches?
thanx for any answers, Claus Reply: <http://www.mnogosearch.org/board/message.php?id=3998> ___________________________________________ If you want to unsubscribe send "unsubscribe general" to [EMAIL PROTECTED]
