Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALTER TABLE is slow
Message
 
 
À
03/08/2002 14:38:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00685910
Message ID:
00685918
Vues:
15
>>It takes only .02 seconds on my PC. Anyway, you can try to run it as one command. It should be faster.
ALTER TABLE ALIAS() ADD COLUMN Url M ;
>>	 ADD COLUMN Image C(20) ;
>>	 ADD COLUMN Image2 C(20) ;
>>	 ADD COLUMN ImageWidth N(2) ;
>>	 ADD COLUMN ImageHeigh N(2) ;
>>	 ADD COLUMN CheckItem L ;
>>	 ADD COLUMN Expand L
>
>Well, I did apply your change and it runs like a flash. This is weird that on a cursor with only two records that it takes 2 seconds here when each command is separate. Thanks

VFP has to create a new file every time you add new column. My guess would be that cursor file is located on the network and for some reason acceess or creation of the file is slow.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform