Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo File is Extemely big with repeated APPEND FROM
Message
De
16/08/1999 23:08:05
 
 
À
16/08/1999 11:53:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00254074
Message ID:
00254394
Vues:
22
>Hi...
>I could use some expert help here...
>
>Please note the following code...
> CREATE TABLE &cLocalDB FROM ARRAY aFlds
>
> nSelect = SELECT(0)
>
> SELECT MAIN
> GO TOP
>
> DO WHILE NOT EOF()
> SELECT (nSelect)
> APPEND FROM &cNetDB FOR Mainkey == MAIN.Mainkey
> SELECT MODACAD
> SKIP 1
> ENDDO
>
>The idea is as I loop through the main database
>MAIN I can find the matching records for each mainkey
>and append them into a local copy of the data.
>
>Even if there is no mainkey's in the table I append from (cNetDB)
>the FPT file becomes very huge (like 420 MB)
>
>In some cases...
>
>The question is why?

You could investigate SET BLOCKSIZE TO 0. In some cases this can improve the storage efficiency of memo fields.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform