What is faster, flat files or a MySQL RAM database?

1 Vote Vote

What is faster, flat files or a MySQL RAM database?

Posted by topdog 270 days ago Questions| mysql ram files mysql All

I need a simple way for multiple running PHP scripts to share data.

Should I create a MySQL DB with a RAM storage engine, and share data via that (can multiple scripts connect to the same DB simultaneously?)

Or would flat files with one piece of data per line be better?

1 Answer Bury

Who Voted for this Question

Answers

topdog
268 days ago

you're gonna hate this answer -- "it depends."

use mysql for larger sets of data that inter-relate.

if you're using a small list of 50 or so items with no need to grow, a flat file will work fine.

Rating: 0