SQL Server Performance Forum – Threads Archive

Shockwave file storage

Hello Everyone,
Right now I am in Database Designing phase for a website development; where we
need to store several thousands Macromedia Flash shockwave (.SWF) files. This website is going to be a highly transactions intensive where thousands of users may be online at a given time period who store their .swf files. My doubt: We do have two options:
A) Store .swf file in SQL server db (in Image datatype)
B) Store in the File Folder of the Web server and just store the File path in SQL Server. Option A) has got its advantages in terms of Maintenance and Security perspective
Option B) has advantages in terms of Performance perspective. I was wondering if someone here in the forum have done some sort of Performance benchmarking between the two alternatives. The reason is we are still finding ourselves in the Phase of "Trade off" between the two and are finding us more inclined towards "Storing Files in DB itself" approach. Any thoughts/statistics/results will be helpful for me! Thanks
Anil

If the application is resource intensive then I would opt from option B, rather than A. Because the option A will have performance contention in providing the application query results. I don’t have any links to refer the benchmarks between the two options, but the option is the general way to manage the image files in the database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks Satya, this helps.

I suggest to search on this forum for similar posts and other members valuable suggestions to accomplish the task, if you want performance then store the image on file server and if you want ease of maintaining images in a database then forget about performance aspect. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>