Re: [twsocket] TWSocket threads

2006-08-29 Thread Robert Chafer
Yes it is specific to asyn execute because it only create a new thread when its an async execute. On Tue, 29 Aug 2006 10:17 +0100 (BST), you wrote: > > I am opening a new connection for each query. When happens is that > > when the connection is closed it never returns. > > OK, so nothing s

Re: [twsocket] TWSocket threads

2006-08-29 Thread Angus Robertson - Magenta Systems Ltd
> I am opening a new connection for each query. When happens is that > when the connection is closed it never returns. OK, so nothing specifically to do with asynchronous execute. Why do you need new connections all the time? Different credentials? A connection pool would be more reliable.

Re: [twsocket] TWSocket threads

2006-08-28 Thread Robert Chafer
I am opening a new connection for each query. When happens is that when the connection is closed it never returns. The ADO Close code seems to wait in a message loop on the async thread ending -- it never does so I get a block in the stack and routines run on top of it. If the async thread is termi

Re: [twsocket] TWSocket threads

2006-08-28 Thread Angus Robertson - Magenta Systems Ltd
> Do you use a different ADO connection for every query (my app does)? There is one connection per table, but it's opened to the server once and left open, unless there are SQL errors when it's reopened. This is not a web application. In my experience, ADO connections can remain open for sev

Re: [twsocket] TWSocket threads

2006-08-28 Thread Robert Chafer
Hi Angus Do you use a different ADO connection for every query (my app does)? On Mon, 28 Aug 2006 14:12 +0100 (BST), you wrote: > > 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

Re: [twsocket] TWSocket threads

2006-08-28 Thread Angus Robertson - Magenta Systems Ltd
> 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 w

Re: [twsocket] TWSocket threads

2006-08-28 Thread Arno Garrels
Robert Chafer wrote: > Hi > > When I use TWSocket based components and they do an async operation, > does the operation actually happen on a separate thread and then the > results get sent via a message to the calling thread? ICS components do not create threads. The components and events are exe