Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread dbisam max number of databases in a folder
Wed, Aug 1 2007 5:52 PMPermanent Link

"Amber Earles"
I was wondering if there was any way to increase the number of database
files you can have in a folder?  I think the max is around 4000.  I would
probably like to double that if possible.

Thank you
Amber Earles

PC/POLL SYSTEMS

Thu, Aug 2 2007 2:45 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi Amber,

On what operating System?

Are you talking about actual files e.g Table.Dat, Table.Idx and
Table.Blb or just Tables in general?

Chris Holland


Amber Earles wrote:
> I was wondering if there was any way to increase the number of database
> files you can have in a folder?  I think the max is around 4000.  I would
> probably like to double that if possible.
>
> Thank you
> Amber Earles
>
> PC/POLL SYSTEMS
>
>
Thu, Aug 2 2007 4:05 AMPermanent Link

Eryk Bottomley
Amber,

> I was wondering if there was any way to increase the number of database
> files you can have in a folder?  I think the max is around 4000.  I would
> probably like to double that if possible.


In DBISAM a folder "is" a database. The number of files (and therefore
tables) that a given database can contain is limited by the operating
system (more precisely, the disk format) so the absolute theoretical
limit for DBISAM currently would be a bit under High(Word) div 2. Use of
long file names and blob fields (which add an extra physical file to the
table structure) would cause the practical limit[1] to be somewhat lower.

Eryk

[1] I don't think MSFT precisely quantify the impact of LFNs anywhere so
I don't think an exact calculation is possible.
Thu, Aug 2 2007 4:50 AMPermanent Link

Arnd Baranowski
Hi Amber

It is limited to 4096 (see appendix C in the manual). However if you
need more you can change the limiting parameter if you have the source
code (like we have done) and recompile DBISAM.

As I understood Tim has restricted it to this amount to keep up the
lockfile performance.

Arnd

Amber Earles wrote:

> I was wondering if there was any way to increase the number of database
> files you can have in a folder?  I think the max is around 4000.  I would
> probably like to double that if possible.
>
> Thank you
> Amber Earles
>
> PC/POLL SYSTEMS
>
>
Thu, Aug 2 2007 12:52 PMPermanent Link

"Amber Earles"
Hello Arnd:

Thank you very much for the quick reply.  We currently own DBISAM - VCL -
STD, but I will see about adding the source.  Can you tell me where to
change the parameter?

Thanks again.

Take care.
Amber


"Arnd Baranowski" <baranowski@oculeus.de> wrote in message
news:C0B4E2BA-CA00-4CA3-AD0A-2A2ADEF85260@news.elevatesoft.com...
> Hi Amber
>
> It is limited to 4096 (see appendix C in the manual). However if you
> need more you can change the limiting parameter if you have the source
> code (like we have done) and recompile DBISAM.
>
> As I understood Tim has restricted it to this amount to keep up the
> lockfile performance.
>
> Arnd
>
> Amber Earles wrote:
>
> > I was wondering if there was any way to increase the number of database
> > files you can have in a folder?  I think the max is around 4000.  I
would
> > probably like to double that if possible.
> >
> > Thank you
> > Amber Earles
> >
> > PC/POLL SYSTEMS
> >
> >

Thu, Aug 2 2007 3:26 PMPermanent Link

Arnd Baranowski
Amber,

it is "MAX_NUM_TABLES" in dbisamcn.pas

Arnd

Amber Earles wrote:

> Hello Arnd:
>
> Thank you very much for the quick reply.  We currently own DBISAM - VCL -
> STD, but I will see about adding the source.  Can you tell me where to
> change the parameter?
>
> Thanks again.
>
> Take care.
> Amber
>
>
> "Arnd Baranowski" <baranowski@oculeus.de> wrote in message
> news:C0B4E2BA-CA00-4CA3-AD0A-2A2ADEF85260@news.elevatesoft.com...
>
>>Hi Amber
>>
>>It is limited to 4096 (see appendix C in the manual). However if you
>>need more you can change the limiting parameter if you have the source
>>code (like we have done) and recompile DBISAM.
>>
>>As I understood Tim has restricted it to this amount to keep up the
>>lockfile performance.
>>
>>Arnd
>>
>>Amber Earles wrote:
>>
>>
>>>I was wondering if there was any way to increase the number of database
>>>files you can have in a folder?  I think the max is around 4000.  I
>
> would
>
>>>probably like to double that if possible.
>>>
>>>Thank you
>>>Amber Earles
>>>
>>>PC/POLL SYSTEMS
>>>
>>>
>
>
>
Thu, Aug 2 2007 4:44 PMPermanent Link

Eryk Bottomley
Arnd,

> As I understood Tim has restricted it to this amount to keep up the
> lockfile performance.

Doh ...I forgot about that ...mostly because I took that out the same as
you did quite a while ago Wink

Eryk
Thu, Aug 2 2007 6:54 PMPermanent Link

"Amber Earles"
Thanks guys - I ordered the source today - we shall try it tomorrow.  Have a
great night.  Smile

Amber


"Eryk Bottomley" <no@way.com> wrote in message
news:25BDB440-BD44-47AA-8CD1-0B6724875C8B@news.elevatesoft.com...
> Arnd,
>
> > As I understood Tim has restricted it to this amount to keep up the
> > lockfile performance.
>
> Doh ...I forgot about that ...mostly because I took that out the same as
> you did quite a while ago Wink
>
> Eryk

Fri, Aug 3 2007 3:34 AMPermanent Link

Arnd Baranowski
Smile

Eryk Bottomley wrote:
> Arnd,
>
>> As I understood Tim has restricted it to this amount to keep up the
>> lockfile performance.
>
>
> Doh ...I forgot about that ...mostly because I took that out the same as
> you did quite a while ago Wink
>
> Eryk
Image