You absolutely need to turn in echoing and locate the specific SQL query which causes the issue. Queries can take excessive time for a very wide variety of reasons.
On Jul 16, 2010, at 12:56 PM, Adrian Price-Whelan wrote: > Hello -- > > I'm working with a database populated with data originally from a file > structure of files that are ~150MB each. We are dealing with a lot of data > that is being stored in the database using the 'ARRAY' datatype, specifically > numeric[]. After loading some of the data into the database I tried > performing a query to get back some data, and comparing it with code that > reads directly from the file system - but the database query took ~50 times > longer to complete. For instance, to retrieve 100 records that contain a few > 4000 element arrays each using the code that reads the filesystem it took > less than a second, but the query on the database took around 25 seconds to > complete. Has anyone else had issues with array types slowing down queries or > does this sound more like another issue? > > Thanks! > Adrian > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.