kenford@stripped wrote:
>
> 1. I'm trying to build a search engine using mysql, what can I do to
> have mysql be very fast multi cpu, lots of memory, clustering what?
>
> 2. Is it normal for mysql to take this long to do a search with just
> 900,000 documents, what about when I have say 10-20,000,000 documents it would
> take for ever.
>
> mysql> select count(dom_country) from url_info_tb;
> +--------------------+
> | count(dom_country) |
> +--------------------+
> | 991851 |
> +--------------------+
> 1 row in set (0.02 sec)
>
> 2.
> mysql> select dom_country from url_info_tb where dom_country='edu';
>
> | edu |
> | edu |
> | edu |
> | edu |
> | edu |
> +-------------+
> 80 rows in set (34.39 sec)
Is there an index on dom_county? Use EXPLAIN on the last query. It
should point you in the right direction.
jim...
