Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO plus APPEND FROM or SELECT - SQL ?
Message
From
28/10/2003 10:33:00
Tamar Granor
Tomorrow's Solutions, Llc
Elkins Park, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: COPY TO plus APPEND FROM or SELECT - SQL ?
Miscellaneous
Thread ID:
00843185
Message ID:
00843544
Views:
19
>Hi,
>
>I am looking to see if we're using the right code to extract some data. Tables are networked, can be from 500Mo to 1,5Go (10 millions to 35 millions records), index keys can be from 25 to 35 bytes long and each tables has 2 or 3 indexes.

If you're in VFP 8, you might test INSERT INTO ... (SELECT...) to see whether it's faster.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform