Shopify Data connector which is preview is very slow and the output for certain tables drops to bytes/sec , how can we optimize this connector?
Do we write the query instead?
Shopify Data connector which is preview is very slow and the output for certain tables drops to bytes/sec , how can we optimize this connector?
Do we write the query instead?
Thanks for using Microsoft Q&A forum and posting your query.
Just wanted to check if your connector slow performance is consistent or random? I would also recommend you to please give a try with query instead of table name and see the difference in performance behavior.
And as this connector is in preview, this could be also due to some underlying issues. Hence we recommend you to file a support ticket if this continues so that a support engineer can take a deeper look and if needed they can involve the relevant driver team to further investigate as needed and improve the connector performance.
Hope this info helps. Do let us know how it goes with Query. Also if you have filed a support ticket, please do share the SR# with us here for tracking it internally.
Thank you
Following up to see if you have got a chance to try with Query instead of table name? If so do let us know how it goes.
Thanks
Just checking if you have got a chance to try with Query instead of table name? If so do let us know how it goes.
Hi @ShaikMaheer-MSFT ,
We'r also facing sort of same issue. We pull data from about 20 Shopify tables. Out of 20, all the time a couple of tables taking ages(approx 2hrs), even if the number of records query returns is in hundreds.
We tried both query and tables. Both gives sort of same performance. All the time same set of tables taking ages.
I hope this helps. Any helps would be really appreciated!
Thanks in advance!
9 people are following this question.