Change
Reduce database access
Issue description
Some frequent queries which are performed on each request should be cached.
Developer comments
Start the server with %mysqld_safe --log_output=FILE --general_log=1%.
In order to measure the effect of the changes, it is necessary to load test the following requests:
* start page
* schema page
* creating a topic type
* accessing a topic type
* range request
* search request
Great improvements. Reduced queries to a third of the baseline.
|
Work sessions8
Start |
2011-01-06T10:49:46
|
End |
2011-01-06T11:45:00
|
Participant |
Robert Cerny
|
Start |
2011-01-09T12:51:16
|
End |
2011-01-09T14:14:30
|
Participant |
Robert Cerny
|
Start |
2011-01-09T18:22:49
|
End |
2011-01-09T19:27:36
|
Participant |
Robert Cerny
|
Start |
2011-01-09T20:06:09
|
End |
2011-01-09T21:37:55
|
Participant |
Robert Cerny
|
Start |
2011-01-10T09:12:50
|
End |
2011-01-10T17:00:00
|
Participant |
Robert Cerny
|
Summary |
Finalized benchmarks.
|
Start |
2011-01-11T18:22:29
|
End |
2011-01-11T18:54:52
|
Participant |
Robert Cerny
|
Start |
2011-01-12T08:34:47
|
End |
2011-01-12T08:41:16
|
Participant |
Robert Cerny
|
Start |
2011-01-21T17:41:01
|
End |
2011-01-21T18:06:11
|
Participant |
Robert Cerny
|
|
We are sorry
This page cannot be displayed in your browser. Use Firefox, Opera, Safari, or Chrome instead.