I had already put together a short test case which as usual is of course working fine, but it's greatly simpler than the in-application use and uses sqlite instead of MSSQL, so I'll bang on it from time to time as I've got a few seconds and I'll see where it goes.
I did notice some behavior that might give a clue. Whenever an eagerly loaded item is missing in the list of results, so are all the values that follow. For example, if I shorten my original list to fifty items, 0-43 might be ok. After item 43, then *every* remaining item is missing, so I would think that it's something that traverses the list of results and once it breaks, it stops the traverse. as far as I know, none of the otherwise eagerly loaded items are already mapped, and the joins are not self-referential. It's a three-way join of three different tables as outlined in the orig post. So it might be something new. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---