View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000016 | NewsStats | Reports | public | 2010-09-19 17:21 | 2018-01-01 21:33 |
Reporter | thh | Assigned To | thh | ||
Priority | high | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | fixed | ||
Projection | none | ETA | none | ||
Product Version | Product Build | ||||
Target Version | 0.01 | Fixed in Version | 0.01 | ||
Summary | 0000016: High execution times for level (-l) queries | ||||
Description | groupstats 'level' queries have execution times of up to one minute even with small table sizes. SQL will need improvement. | ||||
Tags | No tags attached. | ||||
NewsStats: master b802bc3d 2010-10-31 20:43:18 Details Diff |
groupstats.pl: Redo level (-l) query, gain speedup. Do the work in the application, using two separate SQL queries, instead of trying to optimize the single query in vain ... Thanks to Juliane. :) Fixes 0000016. Signed-off-by: Thomas Hochstein <thh@inter.net> |
Affected Issues 0000016 |
|
mod - groupstats.pl | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2010-09-19 17:21 | thh | New Issue | |
2010-09-19 18:00 | thh | Status | new => acknowledged |
2010-10-11 11:34 | thh | Note Added: 0000013 | |
2010-10-11 11:34 | thh | Status | acknowledged => confirmed |
2010-10-11 11:34 | thh | Target Version | => 0.01 |
2010-10-31 21:39 | thh | Assigned To | => guest |
2010-10-31 21:39 | thh | Status | confirmed => assigned |
2010-11-01 22:11 | thh | Changeset attached | => NewsStats master b802bc3d |
2010-11-01 22:11 | thh | Note Added: 0000017 | |
2010-11-01 22:11 | thh | Status | assigned => resolved |
2010-11-01 22:11 | thh | Resolution | open => fixed |
2010-11-01 22:15 | thh | Fixed in Version | => 0.01 |
2018-01-01 21:33 | thh | Status | resolved => closed |
2018-01-01 21:33 | thh | Note Added: 0000084 |