Hi All! I’m running the Shopify connector in airbyte cloud, and just trying to sync the orders table for now… I’m curious what kind of speeds to expect? It’s running 8/9 hours for 1-2M rows, and I’m not sure there’s any more optimizations to make. Does oss / pro / enterprise enable higher speeds?

Based on the knowledge sources, I can provide some context about Shopify connector performance and Airbyte's speed improvements. ## Current Performance Expectations The sync speeds you're experiencing (8-9 hours for 1-2M rows) appear to be within the range of what other users have reported for Shopify syncs. According to [a forum discussion about Shopify to MySQL sync](https://discuss.airbyte.io/t/338), users have observed processing rates as low as 1-2 records per second for certain Shopify streams, which is due to Shopify API limitations and rate limiting. The Shopify connector has specific constraints: - Shopify has [rate limit restrictions](https://docs.airbyte.com/integrations/sources/shopify#limitations--troubleshooting) that the connector must respect - Some streams require multiple API calls per record, which significantly impacts speed - To respect Shopify's rate-limiting, the connector typically doesn't exceed 2 calls per second ## Speed Improvements in Airbyte Airbyte has made significant investments in sync speed improvements. According to the [faster sync speed documentation](https://docs.airbyte.com/integrations/speed-improvements), Airbyte 2.0 (released October 14, 2025) includes faster sync speed as generally available, with syncs running 4-6 times faster on average while consuming resources more economically. However, the [list of connectors supporting faster speed](https://docs.airbyte.com/integrations/speed-improvements#what-connectors-use-faster-speed) currently includes: - Sources: MySQL - Destinations: S3, Azure Blob Storage, BigQuery, ClickHouse Shopify is not currently listed among the connectors with faster sync speed enabled. ## Shopify-Specific Improvements The Shopify connector has received some performance enhancements. The [Shopify 2.0.0 upgrade](https://docs.airbyte.com/integrations/sources/shopify-migrations#upgrading-to-200) implemented GraphQL BULK Operations to speed up several streams, though the Orders stream improvements may vary depending on your specific use case. ## Regarding OSS vs Pro vs Enterprise Based on the available knowledge sources, the faster sync speed feature is available across [all Airbyte tiers](https://docs.airbyte.com/integrations/speed-improvements) (Core, Standard, Pro, Enterprise Flex, Self-Managed Enterprise), but it depends on whether the specific connector combination supports it. Since Shopify isn't currently listed as supporting faster sync speed, upgrading your plan likely won't improve your Shopify sync performance at this time. The performance bottleneck appears to be primarily related to Shopify's API limitations rather than Airbyte's infrastructure or pricing tier.