Hi Chris,
Well, it does have to iterate through each record. If no memo fields, I guess you could construct multi-line inserts using TEXTMERGE but that's probably no better for speed. Is this going across a network? How wide are the tables? Can you post the code so we can see if there's any tweaks that can be done to process it as fast as possible?
On 11/28/2019 11:55 AM, Chris Davis wrote:
Hi All
Is there any tricks I am missing which would speed up a dump of a VFP table into a SQL table.
I have predifined by SQL statement something like this
"insert into mytable (myfield) values (?m.myfield)"
I am then scanning through the VFP table performing a scatter memvar and then executing the SQL.
It works it just seems to take alot longer than I imagined it would.
Thanks IA
Chris.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]