It's an Apache 2 with mod_wsgi. The server setup isn't configured for performance yet, and we can probably tune it a bit. But even when I test with the wsgi-ref server (without parallel requests) the application is slow. Beside sqlalchemy and memcached, we are using django (there are still some dependencies left, since it started as a django-app, but we are working on that *g*), werkzeug (a wsgi toolkit) and jinja (template engine).
The bulletin board is currently the only component which is using (native, not the django hacks) sqlalchemy and it is also the slowest. So it can't be our general configuration, but the board is surely the most database model intensive part (our other components, a portal, a wiki, a blog and a planet can be cached more easily, even with django orm). And in general, I am very happy with the profile log, because there aren't any time consuming parts anymore, but the getattr calls and sqlalchmey orm accesses are so many, that they count however... so I don't know where I can continue optimizing, but about 1 request / sec is simply too slow. Christoph On Apr 7, 1:43 am, Graham Dumpleton <[EMAIL PROTECTED]> wrote: > Independently of database access, what webserver/module are you using > to host the application? > > Graham > > On Apr 7, 9:24 am, tux21b <[EMAIL PROTECTED]> wrote: > > > Hi everybody, > > > I know that this problem isn't related directly to sqlalchemy, but > > maybe somebody can help me thought. We have developed a big web > > application which also includes a bulletin board. There are some heavy > > SQL queries for loading and eagerloading the forum structure, but > > luckily everything is cached using memcached. So there is only one > > query for determining the permissions, which doesn't take long. > > > Unfortunately the forum still remains extremely slow, with productive > > data in use (since we are planning a migration, there is already more > > than enough data available). With extremely slow I mean that it can > > currently handle about 1 request per second. > > > Here is a link to the profile stats, maybe someone of you is > > experienced in optimizing python applications (with sqlalchemy objects > > in the background) and can give me some hints. > > > Profile-Stats:http://paste.pocoo.org/show/38235/ > > > Thanks in advice for every single tip. :) > > > Regards, > > Christoph Hack --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
