MySQL Limits

Bogna_Teuchman
New Member
2 0 0

Hi,

I've looked at the documentation and just want to check: is the platform on MySQL with no limits or is it 250? I looked at

https://docs.shopify.com/api/reference/webhook

under Endpoint.

Sorry if this is plain obvious but I'm a little new to this...

Thx in advance(:

0 Likes
Jason
Shopify Expert
10037 119 1872

Hey Bogna,

The maximum amount of webhooks you can return (via /admin/webhooks.json) is 250. If you've got more than 250 webhooks you are still able to get more, though you need to do it in multiple calls. For that you'd make use of the page number parameter. eg:

GET /admin/webhooks.json
GET /admin/webhooks.json?page=2
GET /admin/webhooks.json?page=3
...

 

★ Winning Partner of the Build a Business competition. ★ http://freakdesign.com.au
0 Likes
Bogna_Teuchman
New Member
2 0 0

Superb, much clearer now. Thank you so much, Jason(:

0 Likes
Milittiora
New Member
4 0 0

Any tool would still use SQL behind the scenes to extract data - the only difference might be that the tool would craft more efficient queries. So, look into optimizing your queries, adding indexes on your tables, and wrapping your queries in views so they would be easier to use. That's why I use mysql developer tools 

0 Likes