I have tested this item ✅ successfully on 881f44e

I can confirm with this patch there is one less query BUT I really dont know enough about this to understand if there can be other consequences

Thanks,

I created that patch some time ago, probably for 3.4.4 and
today I try to show this duplicated query but it missing now.

After joomla 3.4.5 this patch do not change too much.
Anyway can be useful to not run getTotal() if not needed.

I have tested this item ✅ successfully on 881f44e

This PR has received new commits.

CC: @brianteeman, @grhcj

New commit have not change anything, I only rebase to newer stagging branch.

• Method getStart() always run getTotal(), but when $start is 0 then calculating $start won't change anything, because $start can not be less than 0.
• I think that the patch will be useful for sort queries in order (select from table, select count)
  when start=0 (first page)
• In the future - joomla should not run getTotal() at all if number of fetched rows is less than limit from query and $start is 0. Specially when there is a lots of filters and result contains only a few rows.

RTC (maintainer the tests were before a rebase so it should be ok)

Thanks everybody