[Freeciv-Dev] Re: RT sucks

[Paul Zastoupil <paul@xxxxxxxxxxxxx>]

On Mon, Jul 14, 2003 at 07:54:14PM +0200, Christian Knoke wrote:
> On Mon, Jul 14, 2003 at 09:13:42AM -0700, Paul Zastoupil wrote:
> > On Mon, Jul 14, 2003 at 05:52:49PM +0200, Christian Knoke wrote:
> > > Why is that RT search is so slow? I don't want to use it any more.
> > > 
> > > Maybe two 40 GB disks give some boost? Or compile with -O3? Too much RAM
> > > (not cachable)?
> > > 
> > > #-?!"§$
> > > 
> > > Thank you for your attention.
> > 
> > Can some people forward me some common searches? (What fields on the web
> > interface?)  I'll see if adding some indexes can help.
> 
> Fx:
> Ticket content matches unit
> Results per page unlimited
> takes 130 seconds

The database part of that query takes 7 seconds in a fresh DB.  .03~.04 
seconds if its cached.  (I added some indexes, but none that would help
this particular query.)

You also have a couple of other issues.  That query requires 518950
bytes in the response.  I'm not sure what your bandwidth to the RT
machine is, but thats going to take a while just to server that.  Of
course, the machine also has to generate all that information, which
takes time.  We could look into getting a faster machine to run RT (it
is currently a 750Mhz Athlon).

I'm also looking at upgrading to RT3.  I don't know if that will help
or hurt.  But it requires a database upgrade (read: extended downtime),
so I haven't moved forward on it yet.

-- 
Paul Zastoupil