10 Nov
2006
10 Nov
'06
3:45 p.m.
On Nov 10, 2006, at 4:24 AM, Alexander Clouter wrote:
Sounds like, what DB monkeys call, 'SQL Exhaustion' or something. You SQL database is slowing up the whole process...mainly as SQL is not suitable for *live* realtime processing, thats my opinion though.
We have one very hot process that we log to a file first, then in batches stuff into a database. Doing one single insert transaction per log line is death to a DB. If you can do them in batches all in one transaction, it can help a lot.