[sqlalchemy] Case insensitive queries

2008-05-13 Thread GK
I've been digging around the archives, web and source code to figure case insensitive queries using SA, and am posting these notes: (a) for review and comment, and (b) to provide some possible hints for others who may follow For me, a big benefit of using SA is that it insulates me from database

[sqlalchemy] Re: Does SQLAlchemy ORM use column indexes to optimize queries?

2008-04-07 Thread GK
Jason, Thanks for your examples - there are lots of useful SQLAlchemy coding hints in there for me... On Apr 5, 5:30 pm, jason kirtland [EMAIL PROTECTED] wrote: GK wrote: Michael, Thank you for your response - it was very helpful for me. It turns out my main problem was that I

[sqlalchemy] Creating multiple tables based on the same class

2008-04-07 Thread GK
This is another I'm new to SQLAlchemy kind of question... I have two datasets that have exactly the same structure, and I wish to create separate database tables for these that are mapped to/from the structure of same underlying Python class. I looked for discussion of this in the SQLAlchemy

[sqlalchemy] Re: Does SQLAlchemy ORM use column indexes to optimize queries?

2008-04-05 Thread GK
PROTECTED] wrote: On Apr 4, 2008, at 11:09 AM, GK wrote: I tried initially without any additional column indexes, and (observed by watching debug output) the program started off quickly enough, but after a hundred or so records the rate of insertion started to drop off dramatically. I

[sqlalchemy] Does SQLAlchemy ORM use column indexes to optimize queries?

2008-04-04 Thread GK
This is almost my first attempt at using SQLAlchemy, or indeed any ORM system... I'm trying to do a query or create style of operation, along the lines mentioned here: http://groups.google.com/group/sqlalchemy/browse_frm/thread/912c79e8ce005717, but the performance is really slow. I tried