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

Click here to load this message in the networking platform