I have got the Personal Starter kit working well and currently have it hosted online. I have one problem...It seems that the more pictures that I add to an album the longer the site takes to load.
Has anyone else had this problem or know a way around it?
Yes, its a common problem. It is the result of the database getting huge from all those pictures. The best bet is to Add a third table to the database and store the full size pictures in there. You can then replace the column for the full size pictures with
a foreign key for the ID in the full size picture table. You will have to rewrite quite a few methods and stored procedures to accomplish this. The other option is to shrink down your pictures before you upload them. Something like 640 x 480 is preferable,
but 800 x 600 would work. Good Luck =)
FYI: Drag and Drop features are not available to Forms in VS2005 or VS2008, when debugging, if you started VS with admin privleges.
Marked as answer by trevorkeast on May 29, 2008 02:18 PM
The time is eaten up sorting through the pictures table, if you remove the full size pic from this table it will dramatically be reduced. Saving the full size pic to the file system would accomplish the same. I personally feel that there is more room for
errors going with the filesystem solution, but thats coming from someone that does a lot of database work. The choice is yours =)
FYI: Drag and Drop features are not available to Forms in VS2005 or VS2008, when debugging, if you started VS with admin privleges.
Marked as answer by trevorkeast on May 29, 2008 02:18 PM
trevorkeast
Member
367 Points
108 Posts
Slow loading site due to pictures
May 28, 2008 04:03 AM|LINK
Hi,
I have got the Personal Starter kit working well and currently have it hosted online. I have one problem...It seems that the more pictures that I add to an album the longer the site takes to load.
Has anyone else had this problem or know a way around it?
Thanks in advance,
Trevor Keast.
crf250guy
Member
118 Points
37 Posts
Re: Slow loading site due to pictures
May 28, 2008 08:17 AM|LINK
Yes, its a common problem. It is the result of the database getting huge from all those pictures. The best bet is to Add a third table to the database and store the full size pictures in there. You can then replace the column for the full size pictures with a foreign key for the ID in the full size picture table. You will have to rewrite quite a few methods and stored procedures to accomplish this. The other option is to shrink down your pictures before you upload them. Something like 640 x 480 is preferable, but 800 x 600 would work. Good Luck =)
trevorkeast
Member
367 Points
108 Posts
Re: Slow loading site due to pictures
May 28, 2008 01:17 PM|LINK
Thanks for your reply. Could I just ask one further question? How does putting the images in a third table solve the problem?
If I store the pictures on the file system instead, would this solve the problem?
Regards,
Trevor Keast
crf250guy
Member
118 Points
37 Posts
Re: Slow loading site due to pictures
May 28, 2008 08:41 PM|LINK
The time is eaten up sorting through the pictures table, if you remove the full size pic from this table it will dramatically be reduced. Saving the full size pic to the file system would accomplish the same. I personally feel that there is more room for errors going with the filesystem solution, but thats coming from someone that does a lot of database work. The choice is yours =)