I write CMS applications and create different application for admin. When i add some file from admin application for example an image i want to see this in website application. I want to know and want some advise about serving files from a different application.
How can i write a file serving application, how can i upload files to that separate application and also want to now about performance. Which algorithms should i use?
How do developers save and serve files? is this considiration about making different web applications true?
Read the article please. Files do not have to be blob data inside of SQL Server; just the management of accessing files. You can choose to use the NTFS file system which will offer excellent performance. It's not the only way to go, but look at the performance
comparison charts about 1/5 way down the article. The following is a bit more concise:
okan.sarica
Member
2 Points
2 Posts
Storing images,videos,files ... etc in seperate application or server
Dec 12, 2011 08:48 PM|LINK
I write CMS applications and create different application for admin. When i add some file from admin application for example an image i want to see this in website application. I want to know and want some advise about serving files from a different application. How can i write a file serving application, how can i upload files to that separate application and also want to now about performance. Which algorithms should i use?
How do developers save and serve files? is this considiration about making different web applications true?
atconway
All-Star
16846 Points
2756 Posts
Re: Storing images,videos,files ... etc in seperate application or server
Dec 14, 2011 01:49 AM|LINK
Have a look to FileStream storage in SQL Server. You get the organization and security of SQL Server, but the benefits of the file system for storage.
FILESTREAM Storage in SQL Server 2008:
http://msdn.microsoft.com/en-us/library/cc949109(SQL.100).aspx
okan.sarica
Member
2 Points
2 Posts
Re: Storing images,videos,files ... etc in seperate application or server
Dec 14, 2011 06:29 AM|LINK
I dont want to save files in sql server because of performance
atconway
All-Star
16846 Points
2756 Posts
Re: Storing images,videos,files ... etc in seperate application or server
Dec 14, 2011 06:15 PM|LINK
Read the article please. Files do not have to be blob data inside of SQL Server; just the management of accessing files. You can choose to use the NTFS file system which will offer excellent performance. It's not the only way to go, but look at the performance comparison charts about 1/5 way down the article. The following is a bit more concise:
Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008:
http://www.mssqltips.com/sqlservertip/1489/using-filestream-to-store-blobs-in-the-ntfs-file-system-in-sql-server-2008/