RE: Appending from a Cursor

As Ted would say, it depends on your environment. I doubt you will see any significant performance difference with a 100 row table. Big tables? Rotational vs SSD?

--

rk

-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Alan Bourke Sent: Thursday, April 12, 2018 9:30 AM To: profoxtech@leafe.com Subject: Re: Appending from a Cursor

On Thu, 12 Apr 2018, at 2:18 PM, Paul H. Tarver wrote:

Ok, so let me ask the $64,000 question: Which method is faster or better: Append From DBF( or Insert Into as Gene used?

I remember seeing on fox.wikis.com that Insert-SQL can be up to 100x faster than Append from. Not sure how true that is.