[Freeciv-Dev] Re: RT sucks

[Christian Knoke <chrisk@xxxxxxxx>]

On Mon, Jul 14, 2003 at 11:12:16AM -0700, Paul Zastoupil wrote:
> 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)?
> > > > 

> > 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.)

Thank you for looking into that. So it's not the disks.

> 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

I have 60KB/sec when I load a picture from freeciv.org.

> 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).

So Mike is right, a perl issue? Do you know what mainboard the machine has?

> 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

Christian

-- 
Christian Knoke     * * *      http://www.enter.de/~c.knoke/
* * * * * * * * *  Ceterum censeo Microsoft esse dividendum.