Aaron is right -- Webware has no problem executing as many simultaneous requests as the number of threads you are running -- UNLESS you are using an extension library that fails to release the global interpreter lock while it runs. It's possible the Sybase module you are using doesn't release the GIL when it should, although that seems unlikely to me.
You might also consider increasing the minimum number of threads in the AppServer.config file from 5 to something higher, if you expect many of these long-running requests to happen at the same time. You might also implement some mechanism to prevent additional long-running requests from starting while the server is heavily loaded -- for example if you have 10 threads, you might want to ensure that no more than 5 of them are being used for long-running requests at a time, to keep the other 5 available to handle the quick requests. - Geoff -----Original Message----- From: Aaron Switzer [mailto:[EMAIL PROTECTED] Sent: Friday, February 24, 2006 9:12 AM To: webware-discuss@lists.sourceforge.net Subject: Re: [Webware-discuss] Performance on long-running pages Leigh, What's the CPU load like when the reporting page is being accessed? I have something similar in one of my projects and had to introduce caching for the reporting pages due to the way it would hammer the CPU (99% usage for upwards of 10 minutes). Luckily I have the application running on a dual processor machine, so the second processor would be available to handle further incoming requests. I'm still running Webware 0.8.1 myself and have found the only limitation to handling simultaneous and long running requests is CPU availability. Hope this helps, Aaron Leigh Dyer wrote: > Hi, > > I've been using WebWare in a low-volume production environment for a > while now, but as the load has increased I've started to notice some > crack forming. Specifically, one issues that causes trouble is that > when someone accesses a reporting page on one site, which can take a > minute or two to run, other sites seem to be largely unaccessible > until the original request is complete. > > Is this a known issue, or something odd with my particular setup? -- > I'm assuming the latter for now, given the lack of similar complaints. > The server in question is running WebWare 0.8.1 under Apache 2.0 > (using the mod_webkit2 connector) on Debian Sarge, using Python 2.3. > The apps are connecting to a SQL Server database using the Object > Craft Sybase module. If there's any other info I can provide please > let me know. > > Thanks > Leigh > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > _______________________________________________ > Webware-discuss mailing list > Webware-discuss@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/webware-discuss > > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Webware-discuss mailing list Webware-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-discuss ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Webware-discuss mailing list Webware-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/webware-discuss