Chris,
I would consider loading this script only once and establishing a single
connection to the DB server and then making it loop with a time delay
waiting for data to be inserted into the DB - that's pretty much what it
does, right?
The thing is that if you invoke the script every time you
Chris,
You would have to send the table structures including any indexes and also
the real queries.
It would also help if you would send an explain on your select statements.
100+ a minute is not much, I have one server currently doing:
Queries per second avg: 3157.235
Yes, that's per second, n
