[DUG] Access to Database from TCPServer threads

[Phil Scadden]

Okay, I have TCPServer servicing multiple clients. I want to add some
information flows that would require the TCPServer to access single
records that are stored in a database (accessed via ADO). My
initial thought is to make the ADO objects global to the service and use
critical sections to  control TCPServer threads  accessing data from ADO
objects. Each transaction is a single record read only to database so
shouldn't be too tricky??

Alternative would be for each TCPServer thread to have own ADO
object and each one make their own connection to the database. This
seems more memory intensive and raising question of whether ADO
objects are thread-safe anyway.

Thoughts anyone??

----------------------------------------------------------
Phil Scadden, Institute of Geological and Nuclear Sciences
764 Cumberland St, Private Bag 1930, Dunedin, New Zealand
Ph +64 3 4799663, fax +64 3 477 5232