I have not tried DSage. The manager of the cluster did not think it was an appropriate tool for the cluster as the description of DSage suggested it is only for coarse distribution (i.e. projects that can be largely broken into separate parts). Unfortunately, my project involves a sequential series of calculations that involve data from complex database queries, so the project does not lend itself to be broken into separate parts. All the work I have done so far has been with Sage on one machine.
Am I understanding DSage capabilities correctly? Thanks, Dan On Dec 19, 2:20 pm, "Gary Furnish" <gfurn...@gfurnish.net> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
