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