[rt-users] Huge Attachments table in 3.4.4

[Jay R. Ashworth]

On Tue, Oct 25, 2005 at 04:14:46PM +0930, Luke Vanderfluit wrote:
> I'm pretty sure that the lag is caused by an oversized attachments table.
> Are there any suggestions for additional indexes on the attachments 
> table that could speed things up?

For what it's worth, the easiest and most cost-effective solution for
speed problems on DBMS-backed apps is always "get more RAM".

By "More RAM", I mean that (given today's prices, and assuming it's a
production system supporting real people spending real money) 2GB isn't
remotely unreasonable.  Step 2 is "split the code from the DBMS"; that
one may be pricey enough to require more analysis.

It's almost always a first step cheaper than lots of diagnosis time,
unless your time is free.  (Really free, not just no-marginal-cost
free).

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

	"NPR has a lot in common with Nascar... we both turn to the left."
		- Peter Sagal, on Wait Wait, Don't Tell Me!