- 🇸🇮Slovenia jernejmramor
Hello, I'm marking this as fixed since it was released in 1.2. and no further updates were made to this issue.
Here is a website with 3315447 records in recently_read table.
Page load time was 8000 ms on pages which contains recently read block.
A query like
SELECT * FROM recently_read WHERE session_id= 'xyz'
ran cca 2 sec.
I've indexed session_id column in recently_read table and the page load time decreased from 8000 ms to 800 ms and the query mentioned above ran 0,0003 sec instead of 2 sec so the performance problem is solved due to indexing.
It would be nice to modify the module to set up index to the session_id column on module install and for existing installs on the next update.
Fixed
1.1
Code
It affects performance. It is often combined with the Needs profiling tag.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Hello, I'm marking this as fixed since it was released in 1.2. and no further updates were made to this issue.