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 -~----------~----~----~----~------~----~------~--~---