Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Leroy,
I notice that you're doing a replace for every field in the table, but doing them in separate replace statements. I don't know how many fields are in your table but let's assume you have 10, if you've got to write 120,000 records then doing a separate replace for each field will cause 1,200,000 writes to the database. Why don't you wait until you've processed all the fields in a record before writing to the table. Instead of doing an APPEND BLANK and then a separate replace on each field you could simply do an INSERT INTO mytargettable FROM MEMVAR after processing each record, that way you'd only write to your target table once for each record in your source table.
Hope this helps,
Gavin...
>Thanks Gavin,
>
>>Have you tried opening the tables exclusively? Replaces, Inserts, Appends, Etc run faster when the table is opened exclusively.
>
>
>I have used both tables exclusively as soon as I start the program
>If all else fails, I will right something that will run the program at 6:30 in the morning so by 8:00 it would have already run
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement