Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing a Large Dbf > than one gig
Message
De
21/11/2002 19:06:47
Jean Haidar
Arkansas Blue Cross/Blue shield
Little Rock, Arkansas, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Indexing a Large Dbf > than one gig
Divers
Thread ID:
00725544
Message ID:
00725544
Vues:
46
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform