Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 9 of 9 total |
dbisam max number of databases in a folder |
Wed, Aug 1 2007 5:52 PM | Permanent 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 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 AM | Permanent 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 AM | Permanent 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 Eryk |
Thu, Aug 2 2007 6:54 PM | Permanent Link |
"Amber Earles" | Thanks guys - I ordered the source today - we shall try it tomorrow. Have a
great night. 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 > > Eryk |
Fri, Aug 3 2007 3:34 AM | Permanent Link |
Arnd Baranowski | 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 > > Eryk |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |