Loading problem
Posted: Tue Feb 28, 2012 4:04 am
Hellp ppl!
I have a problem with a website if you can help me.
For example, this query, the hosting told me that it loads slowly:
Executed 1 min ago for 3 sec on Database:
select pages.*, subcat.name as subcat_name, subcat.seo_link as subcat_seo_link,cat.name as cat_name, cat.seo_link as cat_seo_link from pages left join categories as subcat on subcat.id=pages.id_parent left join categories as cat on cat.id=pages.CatID where pages.CatID='21' and pages.id<'34883' and pages.visible='yes' order by id desc limit 5
Table pages has over 30.000 rows, and 260mb.
Table categories has max 100rows, is very small.
I have indexes on all fields that are in where condition.
So...where can be the problem?
And where i take this sql and insert in phpmyadmin and execute, the time is 0.3535 sec on executing the sql..
So, where do you believe that is the problem?
Thanks
Wait your response
I have a problem with a website if you can help me.
For example, this query, the hosting told me that it loads slowly:
Executed 1 min ago for 3 sec on Database:
select pages.*, subcat.name as subcat_name, subcat.seo_link as subcat_seo_link,cat.name as cat_name, cat.seo_link as cat_seo_link from pages left join categories as subcat on subcat.id=pages.id_parent left join categories as cat on cat.id=pages.CatID where pages.CatID='21' and pages.id<'34883' and pages.visible='yes' order by id desc limit 5
Table pages has over 30.000 rows, and 260mb.
Table categories has max 100rows, is very small.
I have indexes on all fields that are in where condition.
So...where can be the problem?
And where i take this sql and insert in phpmyadmin and execute, the time is 0.3535 sec on executing the sql..
So, where do you believe that is the problem?
Thanks
Wait your response