I don't know if it is SQLalchemy or MySQL, but I also suspect it is MySQL. I'll give PostgreSQL a try (should be an easy change, right?)
Thanks for the help Dan On Dec 19, 1:24 pm, 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 -~----------~----~----~----~------~----~------~--~---
