This is a Instruction how to measure database performance. This page shall also help to enhance database performance.
select qtime/qcount,qtext from tiki_querystats order by 1
select qcount,qtime,qtext from tiki_querystats order by 1;
select qtime,qcount,qtext from tiki_querystats order by 1;
delete from tiki_querystats;
select sum(qcount) from tiki_querystats;
select sum(qtime) from tiki_querystats;
Example: today (11/20/2003), i added a item in tiki's trackers and got these stats:
select qtime,qcount,qtext from tiki_querystats order by 1;
| 0.070599 | 1 | delete from `tiki_searchindex` where `location`=? and `page`=? |
| 0.10163 | 35 | select `tran` from `tiki_language` where `source`=? and `lang`=? |
| 5.32297 | 2026 | select `includeGroup` from `tiki_group_inclusion` where `groupName`=? |
| 6.52072 | 2004 | select `userId` from `users_users` where `login`=? |
| 6.84396 | 2004 | select `groupName` from `users_usergroups` where `userId`=? |
select sum(qcount),sum(qtime) from tiki_querystats;
| 6159 | 19.166826486588 |
You see the probem?
Flo
1) |
18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
2) |
15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
3) |
19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
4) |
Tiki birthday |
5) |
17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
6) |
21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
7) |
19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting |