[rt-users] httpd speed on rt3

[Douglas E. Warner]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 20 January 2004 09:34, Mike Frazer wrote:
> Consider that MySQL may not be optimized on the RT3 machine, and what you
> are seeing with Perl is actually just Perl waiting on the records to be
> retrieved.  There are quite a few joins in the SQL queries, so an
> unoptimized database could very well be slowing things down.
>
> In my personal experience, as well, MySQL 3.23.xx always seemed to run
> better for me than did 4.0.xx, regardless of what I did to improve the
> speed.  Maybe it was just me but that was my experience.

Well, as I said, I captured the queries that the page loads were doing, and
could replay them in about half a second (out of 8 seconds for the page
load).  On top of that, if MySQL were busy doing a join I would see it eating
CPU, but I don't.  Only httpd.  I think Palle is on the money that it's perl.

- -Doug
- -- 
Douglas E. Warner    <dwarner at ctinetworks.com>     Network Engineer
CTI/PAdotNET         http://ctinetworks.com        +1 717 975 9000
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFADqfpJV36su0A0xIRAqyKAJ9I0KqctKTuGNCmpNQ/F6Qv2HpoWgCgrYWY
DLcIYkrGGeAfbs75Ak0Vy4Q=
=5An2
-----END PGP SIGNATURE-----