At 09:36 a.m. 24/04/2013, russellbelding wrote:

>Thanks for comments Helen. I am developing the code in the main thread of my program first, doing some timing tests and will then estimate how much could be gained by using a separate thread for processing a stored procedure parallel to the main thread. If I do this I'll think about posting an example here.

You might like to have a look at IBO's DMLCaching feature. It is possible to use it at a "global" level (i.e., beyond the boundaries of a connection). It might be helpful for some form of alert from the threaded session back to the main thread, or vice versa.

>The Embarcadero Samples section has a TTHREAD example using sorting. It shows one way to use TThread but is sparse in its use of TThread.

Not talking about Embarcadero's Samples section. Look in your IBO installation directory.

AFAIK, there is no sample there for DMLCaching but there is an ancient Tech Info sheet at http://www.ibobjects.com/TechInfo.html#ti_dmlcaching which might provide a clue or two about how you could use this feature.

Don't overlook Firebird events as a way to inform your main app about what has happened in a stored proc, either.

Helen