which db and php is better for MIS?

pinxue

I will create a mis system including charging fuctions on php/linux.
As stakeholder asked, I will use MySQL or PostgreSQL. I have read comparation article on phpbuilder, it told me postgre is better in transaction supporting, but have some stable issue. My system is not a very heavy loaded one, totle user from 500~2000,cocurrent connection maybe about 20.
Is there anyone have tried this? Would you like tell me your feeling?

And there are two version of php, 3 and 4. I think I should chose php4 for functional and performance. It was be said that php4+zend have some stable issue, would you like show me some cases or give me some advise?

I have a little experince in php and mysql/postgre sql.

smarlowe

I for one have had ZERO stability issues with postgres since version 7.0, and all the issues I had with 6.5.x and before had to do with feeding it ugly sql with a 16 way where clause that made it choke, not die, just grind away for 10 minutes before returning an error.

Postgresql can handle hundreds of simultaneous transactions at a time, and seems to scale better under load than MySQL n my own testing.

They're both pretty good databases, and they both have their uses, but if you are doing financial stuff (i.e. charging) you should probably use transactions, which means you should use postgresql or maybe some other inexpensive/free database (there are others besides just Postgresql and MySQL.

Anon

That is great! Thank you very much. I will use postgreSQL7 and php4 to finish my project.

<maybe some other inexpensive/free database
Do you mean interbase6?

smarlowe

Make sure to read up on things like maximum file handles and inodes, and memory usage per query (i.e. system resources) if you're gonna run ANY database at hundreds of live connections concurrently.

If you're only ever gonna handle dozens of concurrents max, (i.e. intranet stuff, or special interest subjects) then almost any good database like mysql or postgresql on an old P133 with 128 Megs of ram quite nicely, no finagaling required.