ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> General DBA Topics >> Create New Company
http://www.istechforum.com/YaBB.pl?num=1100119271

Message started by Sandy_Fougerousse on 11/10/04 at 12:41:11

Title: Create New Company
Post by Sandy_Fougerousse on 11/10/04 at 12:41:11

I'm using Version 2002.3 and am wondering how many different companies I can create (15?). Am I limited to a certain number or just by what my system can handle?

Title: Re: Create New Company
Post by aricon on 11/10/04 at 12:53:22

You can create as many as you want up to the windows file size limit. In other words if you go beyond 64 MB in the lowest file level, you will find you will start getting errors. (Yes, Lynn, I DID test this quite some time ago - by accident, but nonetheless....).

Title: Re: Create New Company
Post by shadowcaster on 11/29/04 at 15:52:00

My BKGLTRAN.B file is 53 meg
my INVTXN.B is 37 meg

is it time to purge them

I never heard of a 64 meg file limit in windows

JW

Title: Re: Create New Company
Post by Lynn Pantic on 11/29/04 at 16:16:07

DBA can handle individual file sizes up to 2 Gig. Beyond that, the way Pervasive handles the larger files is incompatible with TAS 5 Classic DBA. Haven't tested with Evo yet. I think Lorne may be referring to a limit on the number ofr files in a given folder, not the size of any one file.

Title: Re: Create New Company
Post by aricon on 11/29/04 at 16:51:58

Try creating a data file of say 90 MB. Could be BKGLTRAN as an example. Make sure other files are reasonably similar in size (10-70 MB), and then try doing some transactions. You will start to get posting errors and Pervasive read/write errors.

Title: Re: Create New Company
Post by Tim Keating on 11/30/04 at 07:43:56

BKGLTRAN.B = 125 MB
INVTXN.B = 134 MB

No errors that I'm aware of.

Should I be worried?

Title: Re: Create New Company
Post by aricon on 11/30/04 at 08:04:36

Well, all I can tell you is what I experienced. Started getting weird errors when the data files started getting too large. Seems Pervasive had trouble managing the I/O process and the cache management.

Title: Re: Create New Company
Post by Lynn Pantic on 11/30/04 at 09:02:32

I have never seen errors attributable to file size Tim, I would not be worried. I have seen BKGLTRAN well in excess of a million records.