469,319 Members | 2,398 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,319 developers. It's quick & easy.

Storing Images?

Hi all,

Just wondering whats everyones prefered method of storing images ?

1) File System
2) Database (SqlServer) (Seems to be easier, but has a performance hit)

Appreciate some insight!!!

Cheers,
Adam
Feb 2 '06 #1
9 2063
Well it depends on the size of images..
I will store them in the database if they won't be that large otherwise File
System.
But there is more flexibilty storing it in the database...
Patrick
** How is the weather in Brisbane?
"Adam J Knight" <ad**********@optusnet.com.au> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
Hi all,

Just wondering whats everyones prefered method of storing images ?

1) File System
2) Database (SqlServer) (Seems to be easier, but has a performance hit)

Appreciate some insight!!!

Cheers,
Adam

Feb 2 '06 #2
"Adam J Knight" <ad**********@optusnet.com.au> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
Hi all,

Just wondering whats everyones prefered method of storing images ?

1) File System
2) Database (SqlServer) (Seems to be easier, but has a performance hit)

Appreciate some insight!!!


Generally speaking, I don't have a preference. Of course, sometimes there is
no choice i.e. for public websites where the ISP fully supports SQL Server,
but doesn't allow its hosted sites write access to the site...
Feb 2 '06 #3
File System. Database is definitely a *lot* harder, not easier, and has a
performance hit.

Generally, if the images need to be catalogued, you can use a database to
store meta-data about the images. Sometimes, however, you can use a folder
and/or naming scheme to store the necessary meta-data.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"Adam J Knight" <ad**********@optusnet.com.au> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
Hi all,

Just wondering whats everyones prefered method of storing images ?

1) File System
2) Database (SqlServer) (Seems to be easier, but has a performance hit)

Appreciate some insight!!!

Cheers,
Adam

Feb 2 '06 #4
If store images in file system, is there any limitation of total file number
in a single folder?
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?

Thanks.

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> 级糶秎ン穝籇:On**************@TK2MSFTNGP12.phx.g bl...
File System. Database is definitely a *lot* harder, not easier, and has a
performance hit.

Generally, if the images need to be catalogued, you can use a database to
store meta-data about the images. Sometimes, however, you can use a folder
and/or naming scheme to store the necessary meta-data.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"Adam J Knight" <ad**********@optusnet.com.au> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
Hi all,

Just wondering whats everyones prefered method of storing images ?

1) File System
2) Database (SqlServer) (Seems to be easier, but has a performance hit)

Appreciate some insight!!!

Cheers,
Adam


Feb 3 '06 #5
> If store images in file system, is there any limitation of total file
number
in a single folder?
You've got to be kidding. While the answer is, of course, yes, the number is
astronomical. Take a look at your own current file system under Windows, for
example.
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?
In a Web Farm, all the servers are part of the same domain. Therefore, you
can use UNC paths to the files, as long as each machine has permission to
access those folders.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"RedHair" <re*****@ms40.url.com.tw> wrote in message
news:Oi**************@tk2msftngp13.phx.gbl... If store images in file system, is there any limitation of total file
number
in a single folder?
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?

Thanks.

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com>
级糶秎ン穝籇:On**************@TK2MSFTNGP12.phx.g bl...
File System. Database is definitely a *lot* harder, not easier, and has a
performance hit.

Generally, if the images need to be catalogued, you can use a database to
store meta-data about the images. Sometimes, however, you can use a
folder and/or naming scheme to store the necessary meta-data.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"Adam J Knight" <ad**********@optusnet.com.au> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
Hi all,

Just wondering whats everyones prefered method of storing images ?

1) File System
2) Database (SqlServer) (Seems to be easier, but has a performance hit)

Appreciate some insight!!!

Cheers,
Adam



Feb 3 '06 #6
I should add that, in fact, a file system *is* a database. However, it is at
a much lower level (direct disk read/write) than a database, and has less
functionality, and therfore, overhead.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"RedHair" <re*****@ms40.url.com.tw> wrote in message
news:Oi**************@tk2msftngp13.phx.gbl...
If store images in file system, is there any limitation of total file
number
in a single folder?
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?

Thanks.

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com>
级糶秎ン穝籇:On**************@TK2MSFTNGP12.phx.g bl...
File System. Database is definitely a *lot* harder, not easier, and has a
performance hit.

Generally, if the images need to be catalogued, you can use a database to
store meta-data about the images. Sometimes, however, you can use a
folder and/or naming scheme to store the necessary meta-data.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"Adam J Knight" <ad**********@optusnet.com.au> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
Hi all,

Just wondering whats everyones prefered method of storing images ?

1) File System
2) Database (SqlServer) (Seems to be easier, but has a performance hit)

Appreciate some insight!!!

Cheers,
Adam



Feb 3 '06 #7
Thanks.
Is the FileSystem object of classic ASP only able to work to local file
system?
Is there any built-in .NET class for ASP.NET to access remote file system
directly?
or I need to code a customized class and use it via ASP.NET?

Btw, even we have a separate centralized file server for file storage only,
when
the number of directories and files grow up very large, the disk I/O is a
issue, how
to solve this problem? add new file server and distribute all files to all
file servers
equally?

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> 级糶秎ン穝籇:Oq**************@TK2MSFTNGP11.phx.g bl...
If store images in file system, is there any limitation of total file
number
in a single folder?


You've got to be kidding. While the answer is, of course, yes, the number
is astronomical. Take a look at your own current file system under
Windows, for example.
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?


In a Web Farm, all the servers are part of the same domain. Therefore, you
can use UNC paths to the files, as long as each machine has permission to
access those folders.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"RedHair" <re*****@ms40.url.com.tw> wrote in message
news:Oi**************@tk2msftngp13.phx.gbl...
If store images in file system, is there any limitation of total file
number
in a single folder?
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?

Thanks.

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> 级糶秎ン穝籇:On**************@TK2MSFTNGP12.phx.g bl...
File System. Database is definitely a *lot* harder, not easier, and has
a performance hit.

Generally, if the images need to be catalogued, you can use a database
to store meta-data about the images. Sometimes, however, you can use a
folder and/or naming scheme to store the necessary meta-data.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"Adam J Knight" <ad**********@optusnet.com.au> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
Hi all,

Just wondering whats everyones prefered method of storing images ?

1) File System
2) Database (SqlServer) (Seems to be easier, but has a performance hit)

Appreciate some insight!!!

Cheers,
Adam



Feb 3 '06 #8
Hi RedHair,
Is the FileSystem object of classic ASP only able to work to local file
system?
Use the classes in the System.IO namespace. This includes Directory,
DirectoryInfo, File, FileInfo, and a number of others.
Btw, even we have a separate centralized file server for file storage
only, when
the number of directories and files grow up very large, the disk I/O is a
issue, how
to solve this problem? add new file server and distribute all files to all
file servers
equally?
Where do you think your database stores data? In the file system. Therefore,
if you're going to have enough files and folders in the file system to slow
down the disk I/O, it would have a similar (but worse) effect on a SQL
Server.

Now, SQL Server uses memory for caching, which cuts down on IO usage. But if
you were accessing enough files on the disk to cause an IO issue, the SQL
Server would have either memory issues, due to the caching of these image
files, or, if the memory is throttled down, IO issues, or both.

So, all things being equal, I would still recommend using the file system.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"RedHair" <re*****@ms40.url.com.tw> wrote in message
news:OM*************@TK2MSFTNGP09.phx.gbl... Thanks.
Is the FileSystem object of classic ASP only able to work to local file
system?
Is there any built-in .NET class for ASP.NET to access remote file system
directly?
or I need to code a customized class and use it via ASP.NET?

Btw, even we have a separate centralized file server for file storage
only, when
the number of directories and files grow up very large, the disk I/O is a
issue, how
to solve this problem? add new file server and distribute all files to all
file servers
equally?

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com>
级糶秎ン穝籇:Oq**************@TK2MSFTNGP11.phx.g bl...
If store images in file system, is there any limitation of total file
number
in a single folder?


You've got to be kidding. While the answer is, of course, yes, the number
is astronomical. Take a look at your own current file system under
Windows, for example.
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?


In a Web Farm, all the servers are part of the same domain. Therefore,
you can use UNC paths to the files, as long as each machine has
permission to access those folders.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"RedHair" <re*****@ms40.url.com.tw> wrote in message
news:Oi**************@tk2msftngp13.phx.gbl...
If store images in file system, is there any limitation of total file
number
in a single folder?
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?

Thanks.

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com>
级糶秎ン穝籇:On**************@TK2MSFTNGP12.phx.g bl...
File System. Database is definitely a *lot* harder, not easier, and has
a performance hit.

Generally, if the images need to be catalogued, you can use a database
to store meta-data about the images. Sometimes, however, you can use a
folder and/or naming scheme to store the necessary meta-data.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"Adam J Knight" <ad**********@optusnet.com.au> wrote in message
news:%2******************@TK2MSFTNGP15.phx.gbl...
> Hi all,
>
> Just wondering whats everyones prefered method of storing images ?
>
> 1) File System
> 2) Database (SqlServer) (Seems to be easier, but has a performance
> hit)
>
> Appreciate some insight!!!
>
> Cheers,
> Adam
>



Feb 4 '06 #9
Thanks.
Any suggestions for extend the file system when the disk I/O issue coming?
how to add more servers and distribute existing files and directories to
them
equally?

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> 级糶秎ン穝籇:eZ*************@TK2MSFTNGP12.phx.gb l...
Hi RedHair,
Is the FileSystem object of classic ASP only able to work to local file
system?


Use the classes in the System.IO namespace. This includes Directory,
DirectoryInfo, File, FileInfo, and a number of others.
Btw, even we have a separate centralized file server for file storage
only, when
the number of directories and files grow up very large, the disk I/O is a
issue, how
to solve this problem? add new file server and distribute all files to
all file servers
equally?


Where do you think your database stores data? In the file system.
Therefore, if you're going to have enough files and folders in the file
system to slow down the disk I/O, it would have a similar (but worse)
effect on a SQL Server.

Now, SQL Server uses memory for caching, which cuts down on IO usage. But
if you were accessing enough files on the disk to cause an IO issue, the
SQL Server would have either memory issues, due to the caching of these
image files, or, if the memory is throttled down, IO issues, or both.

So, all things being equal, I would still recommend using the file system.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"RedHair" <re*****@ms40.url.com.tw> wrote in message
news:OM*************@TK2MSFTNGP09.phx.gbl...
Thanks.
Is the FileSystem object of classic ASP only able to work to local file
system?
Is there any built-in .NET class for ASP.NET to access remote file system
directly?
or I need to code a customized class and use it via ASP.NET?

Btw, even we have a separate centralized file server for file storage
only, when
the number of directories and files grow up very large, the disk I/O is a
issue, how
to solve this problem? add new file server and distribute all files to
all file servers
equally?

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> 级糶秎ン穝籇:Oq**************@TK2MSFTNGP11.phx.g bl...
If store images in file system, is there any limitation of total file
number
in a single folder?

You've got to be kidding. While the answer is, of course, yes, the
number is astronomical. Take a look at your own current file system
under Windows, for example.

Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?

In a Web Farm, all the servers are part of the same domain. Therefore,
you can use UNC paths to the files, as long as each machine has
permission to access those folders.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Who is Mighty Abbott?
A twin turret scalawag.

"RedHair" <re*****@ms40.url.com.tw> wrote in message
news:Oi**************@tk2msftngp13.phx.gbl...
If store images in file system, is there any limitation of total file
number
in a single folder?
Btw, if the web site is a web farm, how to store image to a centralized
file system and retrieve them later?

Thanks.

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> 级糶秎ン穝籇:On**************@TK2MSFTNGP12.phx.g bl...
> File System. Database is definitely a *lot* harder, not easier, and
> has a performance hit.
>
> Generally, if the images need to be catalogued, you can use a database
> to store meta-data about the images. Sometimes, however, you can use a
> folder and/or naming scheme to store the necessary meta-data.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> .Net Developer
> Who is Mighty Abbott?
> A twin turret scalawag.
>
> "Adam J Knight" <ad**********@optusnet.com.au> wrote in message
> news:%2******************@TK2MSFTNGP15.phx.gbl...
>> Hi all,
>>
>> Just wondering whats everyones prefered method of storing images ?
>>
>> 1) File System
>> 2) Database (SqlServer) (Seems to be easier, but has a performance
>> hit)
>>
>> Appreciate some insight!!!
>>
>> Cheers,
>> Adam
>>
>
>



Feb 5 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Benoit St-Jean | last post: by
6 posts views Thread by bissatch | last post: by
4 posts views Thread by Rednelle | last post: by
6 posts views Thread by stenospamron | last post: by
3 posts views Thread by T23459 | last post: by
4 posts views Thread by IkBenHet | last post: by
2 posts views Thread by Paulo | last post: by
1 post views Thread by Jonathan Wood | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.