0000016: High execution times for level (-l) queries

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.

thh 2010-10-11 11:34 administrator ~0000013	Can be fixed by doing the work outside the database.

thh 2010-11-01 22:11 administrator ~0000017	Fix committed to master branch as b802bc3d293272d898eb4f2428e7d1809ebe0be9.

thh 2018-01-01 21:33 administrator ~0000084	Mass closign resolved bugs.

NewsStats: master b802bc3d 2010-10-31 20:43:18 thh 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