Performance issues with large category

[cablesimple]

Hi RodG,
If you have them, would you care to share the file(s)/ line number to start at and save me a bit of research time? I need to do something to fix this issue, and I'd rather do it the right way assuming it's not going to take too long. Assuming I have the time to implement a proper fix I'd be happy to pass my code along.

[RodG]

G'day C,

> Hi RodG,
> If you have them, would you care to share the file(s)/ line number
> to start at and save me a bit of research time?

Sure. The 'offending' file is
/admin/includes/functions/general.php

The offending function is:
zen_draw_products_pull_down() it is located around line 243

It seems that I DID get to implement a very crude fix, BUT I never actually got to deploy it for some reason (this was over 6 months ago).

Looking at the code, what I did was to add a check on the number of products read from the database, and if it was over 1000 it re-ran the same query but this time with a LIMIT 1000 restriction.
I can't remember if there was a reason why I didn't simply limit the query to 1000 items in the first place.

Hope this is of some little help.

Cheers
Rod