Asynchronous or synchronous

The place for peer-to-peer support for developing client-server applications with VPME 9.1.

Asynchronous or synchronous

Postby stecenko » Sat Nov 05, 2016 11:01 am

With sqlexec, you can set the connection to be either asynchronous or synchronous.

If you have this statement,
store sqlExec(nConnection, sqlString) to nResult
Does it matter if you are asynchronous or synchronous? Doesn't VFP hang around to receive the result?

And

if you have
sqlExec(nConnection, sqlString)
Does it matter if you are asynchronous or synchronous? Doesn't VFP keep on executing?

I'm trying to speed up a VFP application that does a kazillion inserts to msSql and am confused about synchronicity.
Richard Stecenko
Interactive Computer Services Inc.
Winnipeg, Manitoba
204.453.2052
stecenko
 
Posts: 745
Joined: Mon Jun 21, 2010 8:06 pm
Location: Winnipeg, Canada

Re: Asynchronous or synchronous

Postby stecenko » Tue Apr 04, 2017 2:31 pm

I have a VFP table with 143,371 records.

I have a process to read each record and insert it inot an MS SQL table.

If I run the process asychronously, then it's fast (about 2 minutes). But only about 48,000 records get inserted.

If I run it sychronously, it's slower (8 minutes). But all the records are inserted.

Does any one have any idea what this is about? Am I jamming up SQL server so that it's dropping or ignoring requests to perform the insert?
Richard Stecenko
Interactive Computer Services Inc.
Winnipeg, Manitoba
204.453.2052
stecenko
 
Posts: 745
Joined: Mon Jun 21, 2010 8:06 pm
Location: Winnipeg, Canada


Return to VPM Enterprise 9.1 - Client Server

Who is online

Users browsing this forum: No registered users and 1 guest

cron