doujinai2183 2012-04-02 05:43
浏览 73
已采纳

存储文件大小的效率与每次计算相比?

I have a system for a file hosting site which requires a PHP script to send out the http headers for MIME type and content length of the file.

The problem I'm facing is: would be better to store the MIME type and filesize in the database with the image's entry or to calculate it using filesize() and mime_content_type() on every hit.

I am judging 'better' based on the fastest possible load time but I would like to avoid redundant data and excessive row size if the speed increase is pointless.

  • 写回答

1条回答 默认 最新

  • dongzhuang6247 2012-04-02 05:47
    关注

    Are you handling thousands, millions or billions of images?

    If thousands, then store it in the database. (If you end up serving the same images a large number of times, then it should be a net saving of disk-IO)

    If millions or billions, then properly measure it by profiling both solutions (AB testing) with your real traffic. There are likely too many performance variables in the rest of your code to know for sure!

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
  • ¥30 深度学习,前后端连接
  • ¥15 孟德尔随机化结果不一致
  • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
  • ¥15 谁有desed数据集呀
  • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100
  • ¥15 关于#hadoop#的问题