Is reading from MySQL faster or reading from a file faster?

Question

Hi

I had a doubt that I saw how reading mysql data is slower in the case of large tables ... I did a lot of optimization, but I can’t get through.

I think this will give a better speed if I save the data in a piece of file

Each course will have a separate file. therefore millions of data = millions of files. I agree that it will consume disk space ... but what about the reading process? it's faster?

I am using PHP to read a file ...

Answer 1

( ), (, mysql) , , ( ), ..

, , explain (http://dev.mysql.com/doc/refman/5.1/en/explain.html).

Answer 2

= .

/ = .

= -.

= , .

Answer 3

, .

, ( ) , , , .

Answer 4

, . / SQL, , . , , , DBS.

, (BLOB), , , , , . Microsoft ( ). , Microsoft BLOB SQLServer, , : BLOB , , .

(, , , ...) , , SQL, .

Answer 5

dbms (MySQL ) , , , , , .

Dbms + , (+ ). , :)

Answer 6

, , . MySQL , - , MySQL , .

, MySQL - , . , , FS , ..

Answer 7

, . , .

However, there are many people who believe that relational databases offer too much complexity at the expense of speed. Check out NoSQL on Wikipedia and read about possible alternatives.