User:Ondrej/Bugs/385245
< User:Ondrej | Bugs
Jump to navigation
Jump to search
[38245]
History sidebar supports multiple views, for each query there is one query performed which reads all the data to be displayed on the view. The more data is in the database the longer it takes to display the sidebar.
Testing conditions: - No favicons - Three databases
| Database | Places | Visits |
|---|---|---|
| Small | 88 | 15124 |
| Mid | 589 | 76250 |
| Bug | 3276 | 255363 |
View by Site
Current Situation
Loads all places and their visits, does
Future Situation
View by Last Visited
Correct query, loads all the places and their last visit.
View by Most Visited
Joins with history, what would be useless in case when visit_count gets only increased for proper visit_types (I did not check).