Paul Chamberlain wrote:
>
> 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]
Paul, that's funny, you had the same idea that I did, at the same time.
Kathleen, you should also insure that you have not created any circular
department structures. I.e. there should not be any departments whose
parent's parent is one of your children, etc. If you indeed created
such a circular department structure, your screen would be thrown into
an infinite loop, causing the timeout in question.
Cheers,
-jj
--
if (shannon - jj) * behrens == webEngineer["CLEAR INK�"]:
print "<i>imagination is the only real medium(sm)</i><br>"
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
