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
>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?
--sb--
