Lee Daniel Crocker wrote:
Absolutely; lies, damned lies, and benchmarks, and all
that. Disk
I/O may well be a major culprit. Memory/CPU usage probably isn't.
I'll run some more tests to check some of those things. I'll also run
some tests for things like having the database on a separate machine,
even PostgreSQL if I have the time (I'd appreciate it if the fellow
who said he had it working would send me a patch).
If you meen me with the fellow, I thought I mentioned that I got the data
into a Postgresql DB, nothing more. To do this is easy, but that will not
result in a database you will run a 'speed' test with. And I don't have the
PHP Code running. I only use it to test queries.
To get a pg database which will give useful results, you have to modify the
db schemas in a appropriate way (and later the queries in the php pages).
Without this pg will loose in any test (especially speed measuring ones).
But my Server (a very fast Pentium 1 with 90 Mhz) is pretty happy with the
german wikipedia pages ;)
Nevertheless, I can help on questions concerning a proper implementation,
and I will continue to port the schemas. The next test I will work on is a
propper fulltext search, which is handled by a pg add on. But my Server is
a bit slow in moving of about 27MB data (german wiki) ;)
Smurf
--
Prayer: In the beginning there was IBM ... and IBM created SQL.
------------------------- Anthill inside! ---------------------------