>I've been writing a fairly complex c/s billing platform completely in vfp, and believed (naively) all the info that vfp was a great tool for c/s, and that performance to backend databases was great using odbc, etc, etc.
>
>however, i finally did a benchmark of straight inserts to a sql server table to compare delphi against vfp. i was startled to say the least. delphi provides upwards of 160 inserts per second to a table, while vfp barely manages 30 per second (if i'm lucky). i expected to see a discrepancy of at most 50%, but this is outrageous.
>
>is the problem in my configuration of connection parameters, and is there a way to optimize my performance using vfp (i'd really rather keep to vfp, due to the amount of code written so far)? i'm using sqlstringconnect(), sqlexec() and transactions. the benchmark was performed between delphi and vfp on the same machine talking to the same backend table on the same server.
>
>also, any benchmark info of sql server access from vfp would be very helpful.
>
>please help me with this someone! if possible, please email me as well as posting to this message board.
>
>thanks a LOT.


Are you using views or SQL-Passthrough? I think you'll find one has a speed improvement over the other.