Rick Morrison wrote: >> Such operations will likely trigger a full table scan > > SQLite dates are stored as strings anyway, AFAIK there is little one can do > to avoid table-scans in SQLite based solely on date criteria. I use julian > dates stored as integers when working with large datasets in SQLite, and > convert as needed. Be interested to hear what others do about this. well one can decompose dates into day-month-year triple of ints, but this definitely will need some wrapper to be made easy-to-use (and may need composite keys for example).
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---