One thing you could do, which may not be the best, is insert one (or
some set limit) of rows at a time, then after each sleep for .25 seconds
or something, so that your inserts get spread out more over time, and
there is idle time between them for the selecting clients to complete.
Obviously this
Daniel, also consider selecting as high priority. That will cause
select queries to jump ahead of pending insert queries. That will allow
each select to only have to wait for at most one insert to complete.
Cheers,
-Dana
-Original Message-
From: Daniel Cummings [mailto:[EMAIL