CSV与MySQL性能 [英] CSV vs MySQL performance

问题描述

让我们假设PHP5使用与MySQL5和CSV文件相同的环境。

Lets assume the same environments for PHP5 working with MySQL5 and CSV files. MySQL is on the same host as hosted scripts.

MySQL总是比检索/搜索/更改/添加/删除记录到CSV更快？

Will MySQL always be faster than retriving/searching/changing/adding/deleting records to CSV?

还是有一些数据，PHP + CSV性能比使用数据库服务器更好？

Or is there some amount of data below which PHP+CSV performance is better than using database server?

推荐答案

CSV 不会让您创建快速搜索的索引。

CSV won't let you create indexes for fast searching.

如果您总是需要所有数据从单个表（例如应用程序设置）， CSV 更快，否则不。

If you always need all data from a single table (like for application settings), CSV is faster, otherwise not.

我甚至不考虑 SQL查询，交易，数据操作或并发访问在这里，作为 CSV 。

I don't even consider SQL queries, transactions, data manipulation or concurrent access here, as CSV is certainly not for these things.

这篇关于CSV与MySQL性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！