main logo
Subject: RE: Max Tables opened
Author: Cotton Mr Jerry P
Posted: 2003/05/30 14:08:00
 
View Entire Thread
New Search


>From the VFP3 Help file

Some capacities may be limited by available memory.

Category Feature Number
Table and Index Files
Maximum # of records per table file 1 billion
Maximum size of a table file 2 gigabytes
Maximum # of characters per record 65,500
Maximum # of fields per record 255
Maximum # of tables open at one time 255 (1)


Note 1 is

(1) Limited by memory and available file handles. .CDX files use only
one file handle.

> -----Original Message-----
> From: Testi, Anthony L (UseTemp) [mailto:anthony.testi-eds AT eds DOT com]
> Sent: Friday, May 30, 2003 3:36 PM
> To: 'ProFox Email List'
> Subject: RE: Max Tables opened
>
>
> Anybody have proof that it was 32K per data session in 3.0?
>
> No plans to break 255, just a bet!
>
> Anthony
>
> -----Original Message-----
> From: Chuck Urwiler [mailto:chuck@eps-software.com]
>
>
> Has always been 32K tables per data session. And theoretially
> unlimited data
> sessions. Used to make that point to FP devs who took my
> migration course.
> No more 225 work areas!
>
> So have at it!! <bg>
>
> Why are you asking? Just FYI, or do you plan to near this
> limit somehow?
>
>
> -Chuck Urwiler, MCSD, MCDBA
> http://www.eps-software.com
>
>
>
[excessive quoting removed by server]


 
©2003 Cotton Mr Jerry P
<-- Prior Message New Search Next Message -->