I'm connecting to Shopify via the Devart ODBC driver and Microsoft Access. I'm finding some very long download times.
For example, using a pass-through query in Microsoft Access, with my DSN name in the connection string, I am sending this statement to Shopify:
And that takes 80 seconds to return a single value!
I find the times are about the same if I use a regular query connected to a linked table
Any idea what's going on or what I could try to get this to work better?
Note that ID is the primary key field in that table, and the table only has about 500 records in it. Also, my Internet connection is at about 250 Mbps.
Thanks!
For example, using a pass-through query in Microsoft Access, with my DSN name in the connection string, I am sending this statement to Shopify:
Code:
Select Sku, InventoryQuantity From ProductVariants
Where Id=32459335565411;
And that takes 80 seconds to return a single value!
I find the times are about the same if I use a regular query connected to a linked table
Any idea what's going on or what I could try to get this to work better?
Note that ID is the primary key field in that table, and the table only has about 500 records in it. Also, my Internet connection is at about 250 Mbps.
Thanks!
Last edited: