[AccessD] Pushing data to Azure SQL database VERY VERY slow

[Ryan W]

I kind of took this idea and ran with it. I was able to get the time down
to 5 seconds for one table (500 records) but the larger 6000 row table is
giving me fits because there are nulls. So when I start wrapping colums in
IsNull() it slows down the processing even more.

I'll have to look into the XML route, perhaps.


On Mon, Oct 30, 2017 at 8:49 AM, The Smiley Coder <thesmileycoder at gmail.com>
wrote:

>
> Doing regular inserts against a linked table would take ages. So, instead I
> added code in the frontend which looped the local recordsets, wrote a SQL
> passthrough string like so:
> Insert into tbl_results(ID,value,x,y) values (6,"yeah",6,7)
> Insert into tbl_results(ID,value,x,y) values (7,"nooo",9,7)
> Insert into tbl_results(ID,value,x,y) values (8,"yeah",6,7)
>
>