Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALTER TABLE is slow
Message
De
03/08/2002 14:08:11
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
ALTER TABLE is slow
Divers
Thread ID:
00685910
Message ID:
00685910
Vues:
57
When I call a method in my object which contains this:
ALTER TABLE ALIAS() ADD COLUMN Url M
ALTER TABLE ALIAS() ADD COLUMN Image C(20)
ALTER TABLE ALIAS() ADD COLUMN Image2 C(20)
ALTER TABLE ALIAS() ADD COLUMN ImageWidth N(2)
ALTER TABLE ALIAS() ADD COLUMN ImageHeigh N(2)
ALTER TABLE ALIAS() ADD COLUMN CheckItem L
ALTER TABLE ALIAS() ADD COLUMN Expand L
It takes about 2 seconds to execute those lines which is extremely slow. I am doing this on a cursor which only has two records. Why is it like that? Any way to improve that speed?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform