Did you test for the sql alchemy bottleneck without using dsage? There were some pretty severe (at times) speed issues fixed with dsage in 3.2.2.
On Fri, Dec 19, 2008 at 11:24 AM, Jason Grout <jason-s...@creativetrax.com> wrote: > > Dan wrote: >> Thanks for directing me. >> >> The bottleneck appears to be queries to a MySQL database made via >> SQLalchemy. I will need to make many complex queries, then do some >> simple statistical work on the results. But even the first query is >> taking a very long time. Any guidance you can give is greatly >> appreciated. >> > > Do you know if your bottlenect is a SQLalchemy thing or a database > issue? (My guess is a database issue). In my limited experience and > understanding, it seems that PostgreSQL in general handles complex > queries better than MySQL, and handles concurrent load better as well. > Have you tried that? > > Jason > > > > > --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to sage-devel@googlegroups.com To unsubscribe from this group, send email to sage-devel-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sage-devel URLs: http://www.sagemath.org -~----------~----~----~----~------~----~------~--~---
