Installing all three of these on Windows 2000 was an interesting task to say the least. MySQL is definately the leader in terms of speed, as long as you give it enough memory. But, I wouldn’t put anything on it that you really need - I lost data once in the day that I was messing with it…Not a good sign. Postgres is not much slower than the transaction-capable table type in MySQL, but a heck of a lot more stable than MySQL, in my opinion and from my observations, of course. Didn’t even get to work with MS SQL, but if I can deal with Postgres, I usually do. Interesting nonetheless. I did learn that MySQL had a bulk loader, which I was unaware of. But it’s still not grown up - all the data is chunked into files, with databases mixing with each other. Not good. Each database should have it’s own set of files, like “Real” databases do. I was messing with these, because I got my datalog analysis program to work on Windows using Apache, PHP, and both MySQL and PostgreSQL in Windows…Very cool stuff. I’m gonna write a C++ program, a native Windows app, so that the process becomes easier though…
Comments