Hello Mike;
Expiring timestamps MIGHT be kicking off an ugly series of fetches by global id (i.e. a bunch of single object fetches).
This is my point –– I reduce the lag which ought to create more SQL to be executed, but this extra SQL *appears* to be faster than only looking up the snapshots in the virtual machine (for the circumstances I'm considering) which I would expect to be occurring in both cases on the same volume of in-memory data anyway. I understand the end result and how it is derived, but I don't understand the difference in time taken to get the final result. I might just leave it at that though -- this discussion has been very useful.
cheers. ___ Andrew Lindesay www.lindesay.co.nz _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
