Yes it is possible I think with ablecommerce that adding a column might do something, it is a long shot. I am not sure if they are doing any routines based on table structure or not. But why don't you try removing the column and see what happens?
Also as mentioned before, it is really not a good idea to modify their tables for several reasons. Cody -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Saturday, July 01, 2006 12:53 PM To: discussion@acfug.org Subject: [ACFUG Discuss] JRUN Hangs: (Was:Slow Site Starting on Reboot) Could adding a column to a table do this? I didn't think about that. Gosh I really wish I knew what I was doing... :( ------------------ Report: 12:49:00 Update: Since the last report all has been well until. At 11:59:06 the request query started stacking up. At 12:00:49 the requests hit limit of 10 At 12:18:01 the first of the 10 was processed stating 1,135,313ms transpired By 12:20:12 a que qty of 9~10 went back and forth only processing 6 requests At 12:28:50 the que decreased from 10 to 9 and slowly declined At 12:34:49 the que balance returned to 0 Its: 12:49:00 and the balance is still 0 and processing requests between 200~2000ms each. Note this is a report from my last report which for convenience I will post here. ----------------- Report: 9:57:28 Removed AVG. Rebooted. Services started. Viewed with seefusion. And looked at task manager. 4 requests hit (unprocessed) JRUN at 60-100% continuously Ran up to 10requests. Only 2 of them processed quickly. 10th one hit at 9:25:50am JRUN holding 95~100% Started knocking them out of the processing que at 9:46:57am with 2 strings at 155,702ms Started processing users requests at 9:48:47 in a normal capacity. User requests average 30 seconds. Que steadily brought down to qty 3 at 9:54:48 Maintained 3 in que but processed request in approx 400ms till the request que was brought down to zero at 9:57:28. Maintaining que of zero steadily and JRUN use ZERO resources except for 30% spikes on a quick request as I assume it should be. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -----Original Message----- From: Dean H. Saxe [mailto:[EMAIL PROTECTED] Sent: Saturday, July 01, 2006 10:38 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Slow Site Starting on Reboot Have you modified the DB recently? I've seen bad SQL and/or DB changes that absolutely kill performance. Are you sure none of your code has a cartesian product from a bad join clause? See http:// en.wikipedia.org/wiki/Database and http://en.wikipedia.org/wiki/ Cartesian_product for a definition. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] "What difference does it make to the dead, the orphans, and the homeless, whether the mad destruction is wrought under the name of totalitarianism or the holy name of liberty and democracy? " --Gandhi Find out about my Hike for Discovery at www.fullfrontalnerdity.com/hfd/ On Jul 1, 2006, at 10:02 AM, Robert Reil wrote: > Removed AVG. > Rebooted. > Services started. > Viewed with seefusion. > And looked at task manager. > > 4 requests hit (unprocessed) > JRUN at 60-100% continuously > Ran up to 10requests. > Only 2 of them processed quickly. > 10th one hit at 9:25:50am > JRUN holding 95~100% > Started knocking them out of the processing que at 9:46:57am with > 2 strings > at 155,702ms > Started processing users requests at 9:48:47 in a normal capacity. > User requests average 30 seconds. > Que steadily brought down to qty 3 at 9:54:48 > Maintained 3 in que but processed request in approx 400ms till the > request > que was brought down to zero at 9:57:28. > Maintaining que of zero steadily and JRUN use ZERO resources except > for 30% > spikes on a quick request as I assume it should be. > > Im now happy with it's performance but I wonder when and if it will > hang > again. And I KNOW it will hang again for 20 mins if I reboot again. > This behavior is duplicatable. > > Thanks for all your patience as I rambled, whined, and gave > irrelevant data. > LOL. > > Any direction from here? Seems all I have done is identified the > symptoms. > But without seefusion I would still be whining. > > Robert P. Reil > Managing Director, > Motorcyclecarbs.com, Inc. > 4292 Country Garden Walk NW > Kennesaw, Ga. 30152 > Office 770-974-8851 > Fax 770-974-8852 > www.motorcyclecarbs.com > > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------