Newsgroups : Borland : borland.public.delphi.internet.winsock : 2007 May : Threading, server & DBs

www.cryer.info
Managed Newsgroup Archive

Threading, server & DBs

Subject:Threading, server & DBs
Posted by:"AntonE" (anto..@true.co.za)
Date:Wed, 23 May 2007 23:00:04

If I have a TCPserver that is serving many clients from an IB DB, do I need
to create a Datamodule for each connected user?

If I understand correctly, to have a DM for each connected user context will
be good for speed as it runs in seperate thread, but bad for resources...
Having one DM accessed through idSync(?) is bad for speed, but good for
resources...

My problem is that my app is evolving to get data from 4 DBs, so to create 4
DMs for each client is getting a bit crazy... If only 50 clients are
connected that = 200 DMs with 200 TIBDatabases, 200+ IBTransactions, 2000
TIBQueries, etc,etc.

It would be more efficient to have Fat clients again...?

What to do?
AntonE

Replies:

www.cryer.info
Managed Newsgroup Archive