Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER TABLE is slow
Message
From
03/08/2002 14:08:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ALTER TABLE is slow
Miscellaneous
Thread ID:
00685910
Message ID:
00685910
Views:
54
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
Next
Reply
Map
View

Click here to load this message in the networking platform