>I'm on VFP 7.0. No CursorAdapters in VFP 7 right? Currently my application doesn't use a database container. Do you think I should go through the work of setting up a database and using remote views instead of SQL Pass-thru. Since most of the updates will be less than 500 records, will SQL Pass-thru with scanning the cursor and doing INSERTS not be efficient enough? Will I experience an enormous drop in peformance?
I think scanning 500 records and then sending 500 inserts as one batch (using execute ('insert ...') syntax) should be quick enough.
You can switch to remote views, but I don't have experience with remote views. With remote views you don't have to write extra code.
If it's not broken, fix it until it is.
My Blog