Programming with dBASE - Out of Memory and too many files open problem

Author

Out of Memory and too many files open problem

Dave Brunner

2005-04-14, 3:23 am

I am using dbase plus 2.5 on both Windows 98 and XP. I am frequently getting out of memory errors and or too many files open. What are the maximum number of files I can have open? Can I increase the the number of files and/or available memory?

Thanks

Dave

*Lysander*

2005-04-14, 3:23 am

Dave Brunner schrieb:

> I am using dbase plus 2.5 on both Windows 98 and XP. I am frequently getting out of memory errors and or too many files open. What are the maximum number of files I can have open? Can I increase the the number of files and/or available memory?

1.)
Maxfiles can be 255; in later installations of BDE this is automatically
set.

2.) watch out in BDE Admin for sharedmemsize and sharedmemlocation
You must find your own "good" set of settings.
As a general rule of thumb: 512 RAM -> Sharedmemsize = 8192, depending
on what other apps are running.
Sharedmemlocation should point at a 'distant' offset, where there is
unlikely a conflict with other applications. It is commonly suggested to
use '0x5BDE' as offset.

3.) Make sure in your applications, that you will 'free' resources
regularly, to not have too many data-objects opened, if not necessary.

ciao,
André

David Brunner

2005-04-14, 9:23 am

Thanks for the info. But where and how do I make the changes. I have very limited knowledge with the BDE.
Thanks
Dave

*Lysander* Wrote:

> Dave Brunner schrieb:
>
>
> 1.)
> Maxfiles can be 255; in later installations of BDE this is automatically
> set.
>
> 2.) watch out in BDE Admin for sharedmemsize and sharedmemlocation
> You must find your own "good" set of settings.
> As a general rule of thumb: 512 RAM -> Sharedmemsize = 8192, depending
> on what other apps are running.
> Sharedmemlocation should point at a 'distant' offset, where there is
> unlikely a conflict with other applications. It is commonly suggested to
> use '0x5BDE' as offset.
>
> 3.) Make sure in your applications, that you will 'free' resources
> regularly, to not have too many data-objects opened, if not necessary.
>
> ciao,
> André
>

*Lysander*

2005-04-14, 9:23 am

In article <nZ$wLaPQFHA.432@news-server>, d.brunner@miltonmfg.ca says...
> Thanks for the info. But where and how do I make the changes. I have ve=
ry limited knowledge with the BDE.
> Thanks

Excuse me, I should have pointed there.

I am limited to the translation of my German Windows, but I am sure you=20
will find what I mean:
- go to system/configuration (the place where you also handle settings=20
for fonts, uninstalling software...)
- There you will find a program "BDE Administrator"
- If you open this, you will find two tabs, one is for general settings=20
and one for all your database-aliases.
- You must chose the one for general settings, which is usually called=20
'configuration'.
- there is a helpfile with BDEAdmin which usually explains most settings=20
quite good.

Ask again if this did not help you.

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~
European dBase-conference dBKonEurope on June 3rd and 4th
English spoken conference around different database-topics
::
Info here: www.dbkon.org

Sponsored Links