MySQL 基准测试、预生产
有没有办法在项目的开发阶段对 SQL 查询进行基准测试?
有问题的表中只有几个示例行,但我想在行数达到数千、数百万、数十亿、万亿、无数等等之前对一些查询进行基准测试...
是填充表的唯一选项有数千行样本数据?
我对 SQL 基准测试知之甚少(一无所知),所以详细 = 更好!
谢谢。
Is there a way to benchmark SQL queries while in the development phase of a project?
The table in question only has a few sample rows in it, but I'd like to benchmark some queries before the number of rows reaches thousands, millions, billions, trillions, gazillions, whatever...
Is the only option to populate the table with thousands of rows of sample data?
I know very little (nothing) about benchmarking SQL, so detailed = better!
Thanks.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
是的。
没什么可说的了。您需要完整的数据量。
Yes.
Nothing more can be said. You need full volumes of data.