Kathleen Ballard wrote:
> Everything works, except the departments and items admin screens when the
> department_item table gets more than 500 records. With between 500 - 1500 I
> get erratic page displays.
To me this sounds like you're running up against the 30
second execution limit. That seems pretty slow if it can't
output a thousand records or so in 30 seconds, but I'm not
sure that the freetrade structure has indexes in all the
places that it should. I think I'd double the execution
time limit and try to improve on the indexes. Specifically
I think department_item should have indexes, and sku.Item
should probably have one too. You might even study the
main query or queries in that screen and see if they can
be improved upon.
Here's the line from php3.ini
max_execution_time = 30 ; Maximum execution time of each script, in seconds
--
Paul Chamberlain, [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
