Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table size grows out of control
Message
De
12/09/2003 12:10:47
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00828523
Message ID:
00828548
Vues:
14
You didn't really tells us much...

... but based on what you've described, I'd look for a logic/design error.

good luck


>Ladies and Genteleman,
>
>We have a project where we are pulling data from the database to make reports. Each report is about 1K in size. Also these reports need to be batched by a common criteria. The way we were doing it was creating a record per batch in the cursor and appending the report data to that records memo field. If we have several reports per batch we append all the reports to that memo field in that record.
>
>Here is where the problem comes in. If we have a single report per batch the table is not growing terribly and we procede with a large number of reports processed. If we have the same total number of reports, but several reports per batch the table grows to over 2 Gig and exceedes the allowed limit.
>
>HELP!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform