Thank you all for your suggestions. I did think about the time_out with php
and have already set both the action and the default timeout higher.
And I will check the circular relationship bit tomorrow. I hadn't thought
of that, but it is worth checking. Wouldn't it cause the same problem in
the catalog though?
I am definitely going to try a simpler department screen though. I think
something similar to phpHoo.
Thank you all again for taking the time to help me hash this out. I will be
sure to add it to the FAQ so someone else will be able to take advantage of
your efforts.
Kathleen
::-----Original Message-----
::From: [EMAIL PROTECTED]
::[mailto:[EMAIL PROTECTED]]On Behalf Of Shannon -jj Behrens
::Sent: Monday, August 14, 2000 9:36 PM
::To: FreeTrade
::Subject: Re: [FreeTrade] admin department items screen choking
::
::
::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]
::
::
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
