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 <[email protected]> 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/030054>www.codemag.com > <http://www.codemag.com/article/030054>/ > <http://www.codemag.com/article/030054>article > <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-vfp-perspective-part-i-by-john-koziol/ > > 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-for-importing-files > <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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4svRJWeZUKf7q9Aoi+8m2uV9pB_1RQ=su-w4-mkqbr...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
