Geek asks and answers

If I can store my data in text files and easily handle these files, why should I use a database like Mysql, oracle, etc.

I can easily do my work with text files and a database. But I want to know which one is good in terms of response time. If text files are not the best solution for quick results, then which database is best, again in terms of response time. I can exchange the size for response time. Please help me.

+1
source share
3 answers

Databases are databases for a very good reason; they are ESPECIALLY optimized for: a) efficient storage of your data and b) efficient data retrieval.

, , , .. . , , - , . , , !

, , SQLite, http://www.sqlite.org/

+3

, CSV . , B + ( MySQL InnoDB), CSV ( ) .

, . , , , , . /, , / .

, ; ; , , , / - CSV .

, " ", .

+2

, , , , (/) .

Database performance depends on indexes and query optimization, so in some cases, when you do not need any of the above, and a particular query must scan all the data sequentially in any case, using a text file can be faster, But in general, with the most serious applications, you will soon realize some of the database functions yourself, in which case you will prefer to use a real database in the first place.

0
source

More articles:


All Articles