Error found when try BDE with multiple threads and multiple sessions

Sen Wen

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Error found when try BDE with multiple threads and multiple sessions

Borland BDE support recommends that you set enough memory aside for the OS
then set MEMSIZE=75% and SHAREDMEMSIZE=25% of remaining memory. You may
have to adjust thus even more depending on how much memory your AppServer
needs and also other services you are running.
-Sen

Quote

> We have tried to change BDE MXBUFSIZE from 2048 to 32000 and no
> differences have been found.

> Same error occurs when try to create many processes. (Same EXE running
> multiple times in the same machine)

Brian Bushay Tea

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Error found when try BDE with multiple threads and multiple sessions

Quote

>Insufficient memory for this operation.
>Apparently the error is memory independent, because we try from 32 MB to
>300 MB PC configuration.

>We have tried to change BDE MXBUFSIZE from 2048 to 32000 and no
>differences have been found.

Try changing the Sharedmem size parameter in BDE config

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

weng hen

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Error found when try BDE with multiple threads and multiple sessions

Have you try serialize the creation of TDataModule ?

As of Delphi 3, I've found that the TDataModule.Create(...) is not
threadsafe.

Hope this might help.

Regards,
WH

Sen We

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Error found when try BDE with multiple threads and multiple sessions

BDE 4+

Assuming that you have allotted enough memory to the BDE, you should be able
to up to 256 sessions per client EXE and 48 clients per machine that has the
BDE. In my testing I've only been able to get 255 and that was enough for me
so I did not try to track down why I could not get 256.

There is a TI somewhere on Borland's site.

There is a global TSessions object called sessions you can use to determine
actual number of sessions exists and see it matches what you think should
exist.
i.e.. MyLabel.Caption := IntToStr(Sessions.Count);//Should make
thread-safe

-Sen

Quote

> but now we are having a new problem

> When we try to make more than 75 sessions, BDE reports "Too many
sessions."

> Our project will probably have about 200 (or more) sessions concurrently.

> Is there any parameter about this?

> Regards,

> Sebastin Gabriel Barrasa
> sbarr...@intelap.com

> Sen Wen wrote:

> > Borland BDE support recommends that you set enough memory aside for the
OS
> > then set MEMSIZE=75% and SHAREDMEMSIZE=25% of remaining memory. You may
> > have to adjust thus even more depending on how much memory your
AppServer
> > needs and also other services you are running.
> > -Sen

> > > We have tried to change BDE MXBUFSIZE from 2048 to 32000 and no
> > > differences have been found.

> > > Same error occurs when try to create many processes. (Same EXE running
> > > multiple times in the same machine)