[Rt-devel] Huge number of database queries

[Jesse Vincent]

> 
> > *nod* Improving query count has generally taken a back-seat to improving
> > overall query _performance_, since quite often there are one or two
> > queries in that set that dwarf the run time of all the rest. That said,
> 
> Good performance and also stable/scalable performance that doesn't
> drastically change when the conditions change are the main goals for me.
> I'm not implying that RT does that currently, but that's where I'm
> coming from.


Understood.  Seeing a significant rise in query count per page load as the system scales...shouldn't happen. And postgres with a bit of tuning is very good at keeping the performance scale nicely. But there's no substitute for testing to make me eat my words ;)

> 
> That's always an interesting subject, but I'm cautious about introducing
> more caching because it's a challenge to get it right. I'd hate to give
> up real stability for hypothetical performance ;)

:)