backend very slow

Hey Ray

Just wondering if you'd be able to give me a bit of a steer as have got a site where the front end loads as quickly as needed but the backend from the login page slows to a crawl and not sure what I should be looking for.

It does have a lot of product in the products table (over 3500 items) but surely if that were to slow things down it would only slow down searches in the backend product area?

Thanks

Jamie

It is usually a particular recordset with a slow query that is the culprit and you can usually re-write it, or index the tables better to speed it up.

I usually echo the current time at key points before and after recordsets to narrow down the slow one and then start by indexing joined fields in the database and if it is still slow then I look at the query and figure out how to speed it up by maybe breaking it into other queries or removing nested select statements to use joins instead.