On Nov 4, 2011, at 12:48 PM, Joel wrote: > I have a Pylons application using SQLAlchemy to interact with a SQLite > db. When one of my searches results in an OUTER LEFT JOIN query, the > system takes a VERY long time to return results (i.e., several > minutes). The puzzling thing is that if I run an equivalent query at > the SQLite command line there is no problem. Also, when the RDBMS is > MySQL the query does not take a long time.
This sounds like SQLite's fault -- you can confirm that by running the *exact* query via the command line tool as well. -- Philip Jenvey -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to pylons-discuss@googlegroups.com. To unsubscribe from this group, send email to pylons-discuss+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.