[Rt-devel] Huge number of database queries
jesse at bestpractical.com
Fri Nov 23 12:58:58 EST 2007
> > *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 ;)
More information about the Rt-devel