Personal Web Starter Kit

18 Sep 2006 1:05 AM

esha

I created my first WEB application from Personal WEB Starter Kit template
(C#). I made just minor changes like Connection String and some texts. I
created SQL Server database on the hosting server and I uploaded all files
to the hosting server.
I ran my site http://www.srssite.com and everything was fine. I uploaded 1
picture and tested my site again. I noticed just a very small difference in
speed (opening default page initially and coming back to home page from
other pages). Then I added more pictures. The speed became more slow. The
more pictures I'm adding the slower my site works.

To be sure that this is the problem related to the number of pictures I
created another SQL Server database on another hosting server and repeated
my steps - first run without any pictures (the site is very fast), added a
few pictures (the site became slower), more pictures - more decrease in
speed.

Alrhough I'm a very beginner I suspect that there is some problem with the
design of this template. I've read before many times that it's a bad idea to
store pictures in a database, but this template is using this approach.

Is there anybody who changed this scenario to another one which stores
pictures on the drive and their names and paths in a database? If yes, could
you give some advice how to change the code.

Thank you
Esha

18 Sep 2006 3:56 AM

Cor Ligthert [MVP]

Esha,

The size of a picture is a real performance killer on the web. Look at most
professional websites, even that line speeds are increased are they now all
using very small thumbnail images.

There is a method in the image class in dotNet to make those.
http://msdn2.microsoft.com/en-us/library/system.drawing.image.getthumbnailimage.aspx

I hope this helps,

Cor

Show quote

"esha" <e***@newsgroups.com> schreef in bericht
news:e6jwU6r2GHA.4312@TK2MSFTNGP02.phx.gbl...
>I created my first WEB application from Personal WEB Starter Kit template
>(C#). I made just minor changes like Connection String and some texts. I
>created SQL Server database on the hosting server and I uploaded all files
>to the hosting server.
> I ran my site http://www.srssite.com and everything was fine. I uploaded 1
> picture and tested my site again. I noticed just a very small difference
> in speed (opening default page initially and coming back to home page from
> other pages). Then I added more pictures. The speed became more slow. The
> more pictures I'm adding the slower my site works.
>
> To be sure that this is the problem related to the number of pictures I
> created another SQL Server database on another hosting server and repeated
> my steps - first run without any pictures (the site is very fast), added a
> few pictures (the site became slower), more pictures - more decrease in
> speed.
>
> Alrhough I'm a very beginner I suspect that there is some problem with the
> design of this template. I've read before many times that it's a bad idea
> to store pictures in a database, but this template is using this approach.
>
> Is there anybody who changed this scenario to another one which stores
> pictures on the drive and their names and paths in a database? If yes,
> could you give some advice how to change the code.
>
> Thank you
> Esha
>
>
>