Re: Generics of IDataProvider

[Sebastiaan van Erk]

Hmm.... I seriously doubt that 1 round trip for the entire object is noticeably slower than 1 round trip for the PK's, even if you need to do some joins (assuming of course that you have proper indexes etc).

Regards,
Sebastiaan

Jan Kriesten wrote:

Note that you ARE always querying lists... whether it's just the PK or the whole row, the query (with where clause etc) must still be done. Furthermore, the performance penalty for objects NOT in de database is extremely large in your case (1 extra db round trip per object)!

hi sebastiaan,

How does that work? You use the data provider to query the database and then generate loadable detachable models based on the ids? Don't you get a query per object that way?

regards, --- jan.

in fact, yes. but actually having cached the single objects it's more efficient this way than always querying lists.

smime.p7s
Description: S/MIME Cryptographic Signature