On Jul 19, 2010, at 5:46 PM, thatsanicehatyouh...@mac.com wrote: > Hi Michael, > > Assuming I understood you correctly, I tried the code below. The result was > the same (the query took 486 seconds). Since I autoload everything, I first > adjust the column types to the class you defined. Did I misunderstand > something?
nope. you'd have to produce some profiling results for us or a script that illustrates the issue. > > Thanks again for your help. > > Cheers, > Demitri > > --- > > from sqlalchemy.dialects import postgresql > from sqlalchemy.schema import Column > from sqlalchemy.types import Numeric > > ... > > class ARRAY(postgresql.ARRAY): > def bind_processor(self, dialect): > return None > > def result_processor(self, dialect, coltype): > return None > > for c in Spectrum.__table__.get_children(): > if type(c) is Column: > if c.name in ["values", "inv_var", "and_mask", "or_mask"]: # > numeric[] columns > c.type = ARRAY(Numeric) > print c.name > > spPlateFilename = "spPlate-3586-55181.fits" > spectra = session.query(Spectrum).join(SpectrumHeader).\ > filter(SpectrumHeader.filename == spPlateFilename).all() > > > -- > 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.