MySQL Databases and Files

Question

So, I will work on a home blog in PHP, and I was wondering which data storage method is the fastest. I could go in the direction of MySQL, or I could go with my own little way to do this, which stores all the information (encoded in JSON) in files.

What will be the fastest, MySQL or JSON file?

Answer 1

I would choose a MySQL database - simply because it is easier to manage.

JSON , JavaScripts. , XML PHP (, , , , JSON).

Answer 2

" " , , - , MySQL SQL Server, .

Answer 3

DB ( , ). , .

MySQL, , .
, .

, DB, - SQL (SQLite SQLite.org). SQL, . , .

Answer 4

, , , , ?

10 000 , , .

MySQL , ? - , , , sqlite.

Answer 5

, , - .

CouchDB, , ( ). , ( "-" ).

...

Answer 6

, , MySQL , , .

, MySQL PHP , , ezSQL. ezSQL , , , JSON .

Answer 7

. .

:

1) , , . , .

2) , . ( , ) , , . , "animal.txt" /animal.txt. . , . , , .

. , .

Answer 8

It's really cool. This is a PHP class that manages a flat database with queries http://www.fsql.org/index.php

For blogs, I recommend caching pages because blogs usually only have static content. This way, queries are run only once during caching. You can refresh cached pages when you add a new blog post.