I have done some further analysis by enabling logging (in Postgresql) of all SQL-statements on our test server. This is typical entries in the log from displaying a Sprint backlog. For every ticket I see among other stuff sequensec of:
2011-01-21 12:07:50 CETLOG: statement: SELECT type FROM ticket WHERE id=315 2011-01-21 12:07:50 CETLOG: duration: 0.000 ms 2011-01-21 12:07:50 CETLOG: statement: SELECT summary,reporter,owner,description,type,status,milestone,resolution,time,changetime FROM ticket WHERE id=315 2011-01-21 12:07:50 CETLOG: duration: 0.000 ms 2011-01-21 12:07:50 CETLOG: statement: SELECT type FROM ticket WHERE id=315 2011-01-21 12:07:50 CETLOG: duration: 0.000 ms All together more than 4700 SQL statements to display about 120 tickets. Also, I see a lot of BEGIN/ROLLBACK transaction statemens around single SELECT statements asking for a single value. Displaying "Active tickets" that (just now) lists 450 tickets ends up in 3 large SQL statements that all in all executes in 32ms on our server... Hopefully without stepping on someones toes here I assume that parts of Agilo is written using Python class libraries where SQL optimization haven't been particularely in mind. ;-D Hans On 21 Jan, 11:42, "Hans K. Aspenberg" <[email protected]> wrote: > We have currently 424 items in the product backlog. > > ;-D Hans > > > > Displaying the Product backlog makes Agilo to execute more than 9000 > > > SQL SELECT statements ... ! > > > Some room for optimizations? > > > How many tickets do you have in your Product Backlog? > > > Robert -- Follow Agilo on Twitter: http://twitter.com/agiloforscrum Please support us by reviewing and voting on: http://userstories.com/products/8-agilo-for-scrum http://ohloh.net/p/agilo-scrum http://freshmeat.net/projects/agiloforscrum You have received this message because you are subscribed to the "Agilo for Scrum" Google Group. This group is focused on supporting Agilo for Scrum users and is moderated by Agilo Software GmbH <http://www.agiloforscrum.com>. To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [email protected] For more options, visit this group at http://groups.google.com/group/agilo
