On Mon, 2004-03-29 at 19:00, Chris Gahan wrote:
>
> > Am I the only one using select(), or does my use somehow trigger this
> > problem?
>
> I'm having the same problem. You can read the thread entitled
> "Concurrency issues..." if you wanna see what I've been experiencing.
>
> I think the reason other people don't complain about this is that they
> don't hammer SQLObject as badly as we do. :)
>
> The reason my code hammers SQLObject is because I use my database to
> store image metadata to display a bunch of images on a webware page, and
> every image on the page gets returned by a webware servlet, which will
> result in like 10 servlets all getting called at once, each one does an
> SQLObject query.
>
> I temporarily fixed my problem by setting Webware to only use one thread,
> but that's not "optimal". :)
I've got a public multiuser scenario where I build dynamic calendars
from slightly complex queries - that's the hammering that I'm killing it
with.
Have you tried moving back to 0.5.1 and applying the patch from the date
mentioned below? I'll go catch up on your concurrency thread.
|