At first glance the Personal Web Site starter kit (PWSK) appeared to be really cool for beginners. I decided that I was going to create a site with the PWSK for my daughter. Because the starter kit boasted some nice out of the box features such as manageable photo albums.
So I got some hosting setup, created the site, and copied the files over and come to find out, Crystal Tech doesn't support SQL Express. So I reproduced the required databases for SQL 2K and got it working. Well, at least it appeared to be working. Shortly after adding photos, logging in and out, the system began to error out. I would receive the following error.
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
After some investigation it appears that in the PhotoManager.cs class all connections being opened are never closed. So I made some modifications to the functions and copied the new version up. Well, so far so good. Everything is working fine, connections are ok but now I have discovered another problem. I uploaded about 25 photos. In the PWSK all photos are stored in the Photos table. My 25 photos consume roughly 11MB. Well, much to my surprise, when you navigate to the main page, some initialization takes place and it loads all the photos into memory from the first photo album. This really sucks because not I have to sit and wait for all photos to download.
So in the meantime I will work around this by having my first photo album contain only 1 or 2 photos in it. Needless to say, I am a little disappointed.
I would be interested to hear in anyone else's experiences with this.