XenForo
Administrative
- Thread starter
- Admin
- #1
What do I want to achieve with the query?
I would like to count the reactions that a user has received. And only in a certain forum - in which - this is decided by the PostId respectively the ThreadId.
Unfortunately, the query needs about 5 seconds for each query. This is a mammoth task with the mass of posts approx. 9 million, topics approx. 500k and users approx. 200k.
Is there a way to collect the data faster here? do I have a thinking error in the query?
Code:
Read more
ادامه مطلب...
I would like to count the reactions that a user has received. And only in a certain forum - in which - this is decided by the PostId respectively the ThreadId.
Unfortunately, the query needs about 5 seconds for each query. This is a mammoth task with the mass of posts approx. 9 million, topics approx. 500k and users approx. 200k.
Is there a way to collect the data faster here? do I have a thinking error in the query?
Code:
Code:
SELECT COUNT(*)
FROM...Read more
ادامه مطلب...