Steve Rapaport wrote:

> 
> Someone correctly pointed out today that it's not Mysql's job
> to be Google, and I agree.  But it seems to me that it would be
> fair for mysql to be able to handle searches in under 1 second
> for databases 1 millionth the size of Google.  All I want here
> is a decent flexible phone book lookup, not a search engine.

That may be what you want. But I want a search engine. For my database. I want 
to be able to do search of the million records of inventory in our database and 
find the items with certain keywords, that are currently available for sale, in 
the venue the user is shopping in and within the price range the user specifies. 
This is a combination of database and fulltext search that I think is exactly in 
MySQL's marketplace.

And the current situation where a user fulltext query can take between 1 ms and 
100 secs with no easy way for the application to tell ahead of time is really 
unacceptable.

So I think several things need to be done:

1) full text search needs to be faster (they are working on it).
2) There needs to be some way (ala explain) of figuring out roughly how long a 
particular full text search will take. If I coudl do

EXPLAIN SELECT * FROM inventory WHERE MATCH ($userQuery) AGAINST (title, 
description)

and get something useful for predicting search time. Then I could at least say 
something to the user like:

That query matches too many records. Please pick a more specific query.

Rather than hosing the whole database for 3 or 4 common words.

3) Find ways to use replication and memory to speed up full-text queries. See my 
previous mail about heap tables for a possible example.




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to