On Sat, 2006-02-25 at 17:57 +0100, Christoph Zwerschke wrote: > Leigh Dyer wrote: > > ... 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? ... > > The apps are connecting to a SQL Server database using the Object Craft > > Sybase module. > > Does the Sybase module support connection pooling or did you try with > Miscutils.DBPool? Maybe the module is using locks to ensure thread > safety, and these locks block other Webware threads trying to connect to > the database.
Thanks for all the suggestions -- I think I've got some ideas to work with now. I've been using DBPool, though recently I've been looking at moving to PooledDB from DBUtils. I'll have to check in to the CPU load, but I don't think it would be overly high (the reports are database-limited), and there's a second CPU to help out as well, so it sounds like the Sybase driver might be the problem. We have other apps that use PostgreSQL (which I'm using with the psycopg connector and DBPool) -- I'll see if I can reproduce the problem with some kind of long-running task that uses that database instead. Thanks Leigh > > -- Christoph > > > ------------------------------------------------------- > 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
