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]