Single events too slow

Dear, first of all, thank you for this great plugin!
I am a retired army veteran, trying to make some kind “in memory of” for my brothers in arms fallen in our war in nineties.
TEC is a great tool to do my job. I am using today’s latest version.
But.
After importing more than 6400 events in TEC, things got bad for me. Single events are too slow.
So, I have decided to do my best and find the bug.
And you have some errors in database design. I have added one index to the MySQL table wp_tec_occurrences, and everything is good for me now.

# Problem in your query:
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, CAST( wp_tec_occurrences.start_date AS DATETIME ) AS event_date
FROM wp_posts
LEFT JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id
AND wp_postmeta.meta_key = '_EventHideFromUpcoming' ) JOIN wp_tec_occurrences
ON wp_posts.ID = wp_tec_occurrences.post_id
WHERE 1=1
AND wp_posts.ID NOT IN (6590)
AND ( CAST(wp_tec_occurrences.start_date AS DATETIME) < '2024-07-07 00:00:00'
AND wp_postmeta.post_id IS NULL )
AND wp_posts.post_type = 'tribe_events'
AND ((wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private'))
GROUP BY wp_tec_occurrences.occurrence_id
ORDER BY wp_tec_occurrences.start_date DESC, wp_posts.post_date DESC
LIMIT 0, 1

# Solution:
ALTER TABLE wp_tec_occurrences ADD INDEX(post_id);

Best regards,
Vjekoslav Vucic

• This topic was modified 8 months, 3 weeks ago by Vjekoslav Vu?i?.

The page I need help with: [log in to see the link]