Slow downloads through ODBC driver

[enargins]

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!