Hi Antony,
there's the good old DOS limit of FILES = xxx in Config.sys (or FILE
HANDLES = xxx in Novell). This was the main limiting factor. Each DBF, each
FPT, each CDX is one file handle. The max number of file handles was 255
(254 in Novell). That's why there always has been that limit in FoxPro and
early versions of VFP. Thus, even though there's no such tight limit in
WinNT/Win2K, that old 255 files limit still applied up to at least VFP6.
That's different to the Workareas, which have a theoretical limit of 32767
per Datasession. Remember that SQL-SELECTs are using different own
workareas, as well as Local and Remote views. And the internal query engine
uses several selectareas in between building the query results for
intermediate join-resulttables...
Servus
wOOdy
|\_/| ------ ProLib - programmers liberty ---------
(.. ) Unsere MVPs bringen den Fuchs zum Laufen...
- / auf www.prolib.de und www.AFPages.de
-----Original Message-----
From: profox-bounces /AT/ leafe .D.OT com [mailto:profox-bounces@leafe.com] On Behalf
Of Testi, Anthony L (UseTemp)
Sent: Friday, May 30, 2003 10:25 PM
To: 'ProFox Email List'
Subject: RE: Max Tables opened
Now I am confused.
Are we saying that there is a Max of 255 Tables open in 32K Work areas.
What good is having 32K work areas if one can only open 255 tables?
Anthony
©2003 Juergen Wondzinski |
