[Ur] little benchmark on querying a table only

[Gian Perrone]

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

On 12/20/10 8:29 PM, Marc Weber wrote:
> Its the time output of zsh. ab is the benchmark tool which ships with
> apache. So you don't see the CPU time of the server process, but the one
> of the benchmark tool. The "total" time is the time it takes until you
> see the shell prompt again.

I see.  Is the server and client running on the same machine?  If they
are, I can't see that as being a particularly valid test.

> I also compared with http -t20 and -c 10 (concurrency). Apache + PHP was
> a lot faster as well.

The effect of caches in the database couldn't be ignored, either, unless
you are purging the tables in-between requests.

> PHP time drops very fast if you start load configuration options loading
> classes. In a real application urweb would outperform PHP very fast.

Yeah.  I think on these very small workloads it's probably not
statistically meaningful to make comparisons unless they are averaged
over a large number of samples.  For larger applications and workloads
the comparisons could become meaningful.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJNDwb8AAoJEDd5xfOXfbYMn64IALBDZNCUMvUeksIQMj6R4r+m
wA0zwQOMaAN381GxdPKBcqryu42EYjH3/1Oz7qe2Ka5vEZ5IANncibCakaPgYWMD
OqTaVse9uHGCXBLdo/eI8hcM6rmCFPCKHEBVOGDIKza/YFkxZygZJftbGBmMfA+e
BRTRu+prTKHYp+Y+QEyYyNeyz8RNyEz+LbgoJsdDD0+XsSQ6rk3OfdJkYfzGPW4r
hT5I8+YQrlcOztEJT8lsI/6O7fmJgwgg0TPWNeZoX/rGLbrP8KBDIMOdqsaaGXRS
pB3LhfPKN6lhT4cjiCZZwNBENbfpUqMRD5sVIPLzix286Mkdy/y0egCvgBP5b8Y=
=UXZy
-----END PGP SIGNATURE-----