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:
Select Sku, InventoryQuantity From ProductVariants
Where Id=32459335565411;
And that takes 80 seconds to return a single value! The table only has about 500 records in it.
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?
My Internet connection is at about 250 Mbps.
Thanks!