> There is a (very) subtle bug in ADO
> that means ADO async threads sometimes hang when they are released.
> This happens about one time in 100,000 calls (by hang I mean they do
> not return -- the app still runs as they are in a message loop).   

I'm currently testing a new application that is writing approximately 
five to 20 SQL records a second asynchronously using ADO to five 
different tables, several million rows over the last two weeks, all 
running essentially with a single thread with approximately 20 wsockets 
listening and sending (and two serial async threads).  I've not seen any 
ADO hangs.  

I do get 'Operation cannot be performed while executing asynchronously' 
about once a day, where I close the database, reopen it and then post 
the queued records, but this might be a fault in my own logic.  My 
testing is with an XP Pro service against SQL Server 2005 Express 
running on Windows 2000 Server.  

Angus
-- 
To unsubscribe or change your settings for TWSocket mailing list
please goto http://www.elists.org/mailman/listinfo/twsocket
Visit our website at http://www.overbyte.be

Reply via email to