The Joomla! Extensions Directory ™

Before I get to the bad I should say that overall I like this component. A pretty good effort at a ticketing system.

My issues are with how it does things.
I added all 700 users in my joomla site to the ticketing system (why they needed to be added is one of my issues, they exist in joomla that should be enough)
When I logged into the front end as an administrator I found that it was taking a long time to display the page even though the default was to display only the first 5 users.

turned on debug and found that rather than limiting the number of users it was getting the details of all 700 users, and what more after it retrieved those details in 1 query it then proceeded to load the details again for each individual user, and because I was an admin it used not 1 but 2 queries to get the user data. This means that with 700 users this component was doing over 1400 queries to build a list that ultimately only showed 5 users on the page.

All of the front end code seems to work this way.
An initial query to find all of the records from the required table, then another query for each record found to find the data again.

For a large site like mine this means that there are way to many queries being run.

Also the pagination does not work well because as mentioned above it grabs all the data first and then determines what it should display, but there is also to list size parameters for the component
front page tickets and sub page tickets.
Now I can sort of understand that this is so that the front page can have more or less than the rest, however the calculations that it does to determine the pages are wrong
when i changed the system from 5 on the front page to 15 and set the sub page to 30 it showed 50 pages of users when I was on the first page and then only 25 page when I was on the second page
In reality it should have shown about 25 or 26 pages all the time because the first page was 15 and the rest we 30 but it doesnt take the difference between the numbers into account

I would also like to see the ability for admin to reply to tickets in the back-end of joomla (as an administrator that is where I spend most of my time)

Final issue was that there is, so far, 1 short tag used in the front end to display the copyright information, and since I have short tags turned off (as any good Joomla developer should) then the copyright does not display correctly.

FYI - in half an hour I hacked and wrote the display so that rather than 1400 queries to display the list of users in the front end it took only 2 queries. Also from what I can see all of the front end display basically has these same problems, multiple queries (an initial query to get the list of records and then another one for each record) and pagenavigation using all of the records rather than using limits in the initial queries.