Well I last thought the slowness to our site was due to a database problem. I was only half right about that.
I installed a new (same) installation of zen cart. Created a new database(which created itself on a different server than the original store database, both seperate from the hosting server) and transfered the original database to the new store database. Everything ran smooth. link: http://www.clearwateroutdoor.com/testshop/
Then I changed the location in the config files of the database location in the original store to point towards the new database. This solved the problems we were having inside the admin panel while dealing with products/categories. Everything is now speedy.
Back in the original store, Http://www.clearwateroutdoor.com/shop/ things are not so. On any page that a product loads, the site is very slow. Other pages such as the site map, contact info, shipping etc (located in the footer) or any top level categories(links from the brown navigation menu except for kids) are of normal speed. link:http://www.clearwateroutdoor.com/sho...index&cPath=60
Anyone know why pages that list products would be slow? Possibly something to do with the images or image handler? thanks for the help.