hi i have cascade= option of relation switched automaticaly between "all" and other values, and nothing. so i used cascade=None as nothing, hoping it will get the default behaviour. the result was some query got 6x slower (actualy thats why i went hunting it)...
nope, it happens that source-wise, exactly cascade=False triggers the default behavior (whatever that is) and nothing else. Not really intuituve, well, fine, i'll fix me code, but the question still remains: why cascade=None or cascade='' or whatever empty thing makes queries (sqlite) sooo slow. i've compared the sql of the query - it's same. something in the schema went wrong? or result-processing? or what? is it worth chasing or there is a known reason? and a related suggestion: why not use symbols e.g. some singleton called DefaultValue, instead of any hard-to-guess default values (be them False, None, '', whatever)? the actual default values are mostly set up later, so the if something is DefaultValue: something = actual-default-value is there anyway. ciao svilen --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---