Question

哪些是较好的——利用甚高的聚合功能COUNT来回选定的发生率或人工计数,并在插入作业期间将计数纳入外地? 考虑到排雷中心的职能是搜查桌子或指数,并在人工计算时将结果分类,我只是找回外地。

Answer 1

如果你手工操作,

You do extra work that is not required
You ve to remember to do it for each insert and delete operation
You slow down because of extra operations
You will have inconsistencies when the table is manipulated directly
In MyISAM table the count is already retrieved as a field by MySQL
In InnoDB it s a little slower, but subsequent calls are cached, so only the first one will be slow

努力使房舍管理事务比房舍管理司的工作做得更好,这不是一个好的想法。房舍管理处体现了多年的经验和选择。

Answer 2

IMO you should always use MySQL internal functions to get results/data from your database.
But it depends also on what you re counting, which data you re retrieving, which operations you need to perform and so on.
Generally, if you can, use MySQL functions: they are fast and reliable!!

Answer 3

我认为,在人工计算时,你必须明确(标准代码),而如果你使用Mysql查询,则由Mysql服务器管理。在另一起案件中,如果其网络应用程序或你正在建造的东西,则会增加额外的间接费用。我认为, for计会是明智的!

友情链接