Hello, I have a table that stores binary file data in one column and information about the file (file name, mime type, sha1 sum, etc) in the other columns.
Currently when I use the mapped class, it loads the file data (adds to network and memory load). What I would like to do is check the sha1 sum first and then only if needed load the file data. I have been looking into the 'lazy' and 'dynamic' loading options, but they seem to be designed for loading a separate class and not just a single heavy or large property (column) like my file data. Any advice for this situation? I was considering mapping two separate classes, one to the light columns, and another to the heavier data column. I have not mapped separate classes to the same table before though, so any hints on this would be great. Ideally I would like just that data property to lazy-load when accessed, but not sure if there is a 'lazy load this column' setting somewhere. My table is something like: files: - file_name - mime_type - sha1_sum - file_data --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---