Quote:
Originally posted by blazin
also ditch the text files and use mysql. (with enough RAM the database will stay in memory)
|
Mysql does not scale well.
It doesn't perform complex joins or subselects.
It doesn't natively support transactions.
It has no atomicity with regard to locking.
It has no support for stored procedures, triggers, or foreign keys.
With lots of simultaneous inserts/updates it will stall too much.