On Wed Feb 25 2009 18:45:06 Matt Nelson wrote: > Watching it throughout the day it looks like NDO runs via its daemon, and > does insert to the same table as the selects are running from. It also > does deletes, occasionally. We ran out of our 100 connection limit about 4 > times today and each of these times the inserts and deletes where running. > I'll keep ya'll posted if I get to the bottom of this, but I think there is > something else going on that I'm still missing...
Well, if a write gets in, all the reads will be serialized behind it. The idea is to treat those tables as a cache for collecting the data, then generate your report into another table for viewing--the idea that copying the report data will be a very quick insert-select write query and not block all the reads when they come. In fact, if the insert-select query only appends to the report table (and it has no holes), it won't block reads at all. /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
