User:Ondrej/Bugs/385245
[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 (they seems to slow down display of the sidebar and should be solved separately).
- Loading time is just the time spent in the database engine.
- Three databases of various size:
| Database | Places | Visits |
|---|---|---|
| Small | 88 | 15124 |
| Mid | 589 | 76250 |
| Bug | 3276 | 255363 |
Views
View by Date and Site
Current Situation
Future Situation
View by Site
Current Situation
Loads all places and their visits, does
Future Situation
View by Date
Current Situation
Loads all places and all related visits to memory, processes the data in memory and creates groups by days. With big database showing the sidebar or clicking on "Older than 6 days" can take tens of seconds or several minutes. Firefox is frozen at that time.
| Database | Loading Time | Records |
|---|---|---|
| Small | align=right | align=right| |
| Mid | align=right | align=right| |
| Bug | align=right | align=right| |
Future Situation
View by Most Visited
Current Situation
Joins places with history, this could be avoided if the visit_count is only updated for proper visit_types (to be checked).
Future Situation
Requires incremental loading.
View by Last Visited
Current Situation
Correct query, loads all the places and their last visit.
Future Situation
Requires incremental loading.