>I have a program that gets data from sql server and puts it into vfp tables (free tables). From there reporting is done against the dbfs. This needs to be done multiple times a day. One table, tblactivity, has about 500K records.
>
>Regarding the following code:
>lnr=sqlexec(lnh,"select * from tblactivity","curactivity") && takes 30 or 40 seconds
>copy to tblactivity_vfp && takes a few minutes?? haven't benchmarked exactly, but it is slow
>
>Is there a way to speed this up? Years ago I used BCP, don't remember much about it right now, but thinking it would speed up writing to a text file, but then I'd have to append into a dbf anyway.
>
>Is there any way to bypass sending results to a cursor first, a way to use sqlexec to go straight to a dbf?
>Any way to speed up the copy to?
>
>Thanks.
BCP is the way to go or SSIS package scheduled as a job to run.
I suggest to look into second alternative.
If it's not broken, fix it until it is.
My Blog