No. There's lies, damned lies, and then there's benchmarks.
I've seen benchmarks showing VFP really slow parsing text files, because the coder had never seen _MLINE nor knew how to use it. VFP can be wickedly fast if properly tuned. As George Goley pointed out, all you need to do is take out the slow parts.
Also, the OP's article has VFP using raw APPEND, a single command, while C# is using ODBC and transactions on every single insert. Totally unfair. If you were bulk-loading a SQLite database, you'd use the built in import tools, and not a scripting language through an ODBC driver.
https://cs.stanford.edu/people/widom/cs145/sqlite/SQLiteLoad.html
But if the original post is saying that bulk data load is faster than passing individual transactions through ODBC, well, yeah. But not a fair apples-to-apples comparison.
On Mon, Apr 11, 2016 at 10:30 AM, Fernando D. Bozzo fdbozzo@gmail.com wrote:
I've read a lot time ago that this is true because C# string optimizations where made by part of the Fox Team :)
So yes, I believe that the same people that made VFP Great can enhance some parts and implement them on another language.
Edit: Found some old articles: http:// http://www.codemag.com/article/030054www.codemag.com http://www.codemag.com/article/030054/ http://www.codemag.com/article/030054article http://www.codemag.com/article/030054/030054 http://www.codemag.com/article/030054 https://blogs.msdn.microsoft.com/vsdata/2005/02/10/exploring-vb-net-from-a-v...
Regards
On 2016-04-09 23:34, AndyHC wrote:
I was browsing through the AVFP** discussion site and came across this link re. Foxpro speed:
http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-f... http://stackoverflow.com/questions/34667084/c-sqlite-performance-vs-foxpro-for-importing-files
** anyone using it? I've got a test setup running fine locally and on GoDaddy / BigRock
From the article: "If you needed to parse the lines, then VFP is quite
slow on string operations, compared to C#."
Really?!??
[excessive quoting removed by server]