It is not that mysql it slow, its your database design and the fact you have
2.5 million records in the table.
It is not clear from your description of the problem what you are trying to
do, so giving advice is that much harder. If you are creating an index on
the column hari, it will take a long time. However this time is negligable
because you only do it once, and never again. But if you are talking about a
query that uses the column hari going slow, making it a key in the table
will speed up your query considerably.
Hope this helps.
> This table contains more than 2.5 million records. I
> created index on column hari. It needs more than 3797
> secs, and have not finished yet.
>
> Anybody has advice?
---------------------------------------------------------------------
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
