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 _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
