On Mar 18, 2004, at 1:30 PM, Corporate wrote:

Two words! Thread Synchronization! (above the database API in your code).
Works like a charm.

I just sat down with a cup of coffee and came to the came conclusion--if I keep only one connection to the database and do the mutexing myself, I get better control and I get to use temp tables, too!


I think I'm going to queue up data as it comes in, then flush it to the database 5000 or so rows at a time. That should be fast enough to keep the UI from hanging and big enough to get a boost from the transaction.

-D


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to