Questions tagged [sql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
43 views

Craft CMS hangs when deleting a field then throws 504

We have an instance of Craft CMS running that has a lot of content entries and a lot of fields, using Neo and SuperTable. At some point, something changed and now when we try to delete one of the ...
1
vote
1answer
28 views

Mass enable entries

I'm trying to set statuses to enabled in mysql. Around 150k entries. The tables are elements and elements_sites. Set status to 1. The query runs OK. In the cp is also everything fine but entries don'...
1
vote
1answer
29 views

Least CPU intensive way to get number of matching elements?

Which is the least CPU intensive (SQL-intensive) way to get the sum of products that are relatedTo a category? Like this? {% set productCount = craft.products.relatedTo(category)|length %}