Linux + Apache + PHP + ??MySQL/PostgreSQL??
 

Good afternoon

We have a system that is accessed through the local intranet will add some entries at a SQL database and also will have a search system.
For that, Linux + Apache + PHP + MySQL would do the job just fine.

But also, in that same db, will have two other systems, and those two combined will sum more than 2000 records a day (which means, adding and deleting from the db).

Now I want to know if MySQL will be able to handle such load. I heard that for things like that PostgreSQL would fit way better.

Can someone help me out with that?

2000 rows a day seems to be very minor. You should have no problems with Mysql.

Hum
How many info traffic do u think MySQL can handle daily?

Easily 100 users at a time doing significant processing, depending upon the size of the server. Assuming a reasonably sized server, I would think 100 times your estimate could be handled.

Both MySQL and Postgresql would be fine... At work we have a Mysql database that is creating 20,000 rows a day when processing a job (very high DB load) and MySQL hardly notices...