Slow selects

Forum Moderators: open

Message Too Old, No Replies

Slow selects

orion_rus

8:40 am on Dec 9, 2006 (gmt 0)

Hello world, i have some slow selects from database.

I have MYSQL 4.12 and some databases
One database have table article, there 7500 articles are placed.
If i have select to it sometimes i can wait for 5-10 minutes to make full select of database. I have primary key id in it and no other keys.
Can anybody advise me solution?
Thanks in advance

justageek

12:40 pm on Dec 9, 2006 (gmt 0)

It is almost certain an index missing. If you post the query it would help.

JAG

physics

6:56 pm on Dec 9, 2006 (gmt 0)

If you have an articles table a fulltext index is probably the way to go. Also if you're searching more than just the article text then you'll want to create an index on all the fields that you're searching and use MATCH ... AGAINST:
[dev.mysql.com...]
This should speed up your searches.

orion_rus

1:51 pm on Dec 12, 2006 (gmt 0)

Count: 1 Time=932.00s (932s) Lock=1.00s (1s) Rows=14826.0 (14826),
SELECT * FROM `orionych_best`.`catalog_sites` LIMIT 14826

Slow selects

orion_rus

justageek

physics

orion_rus

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week