Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a Large Dbf > than one gig
Message
From
21/11/2002 19:06:47
Jean Haidar
Arkansas Blue Cross/Blue shield
Little Rock, Arkansas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Indexing a Large Dbf > than one gig
Miscellaneous
Thread ID:
00725544
Message ID:
00725544
Views:
45
one of our client free DBF is growing very fast and the size is now close
to 1.3 gig. Client Run an indexing utility that run ok by itself but when
it ran under a scheduler written in VFP, it is reporting the following eror:

" Not enough memory for file map (Error 1150)"

The server that this test is running at has 512Mg
then the same test ran under with one gig Server and still did not get a
successfull indexing.

The total size of DATA directory indexed is 5 gig, The biggest file is 1.3 gig in size, Free disk space is around 30 gig.


I ran the same test on windows 2000 Server with 512Mg and scheduler would
take tremoudous amount of resources when the indexer routine is laucnhed then Server lock up and had to end the task.


I checked VFP help regarding the size of cdx, I do not see any limitation, I do see that max size of one table is 2 gigabytes.
do you think this limitation apply to cdxs as well?

Any help on this would be greatly appreciated.


jhhaidar@pacbell.net
Jihan Haidar
Software Engineer
jhhaidar@sbcglobal.net
Next
Reply
Map
View

Click here to load this message in the networking platform