Database file size?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I'm using v3.11 with MS Access. My site is at a point where it will not load. The Access file is over 9 megs, and that's with all products and orders removed. Is this normal to have a file this size?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
paulyork Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 23-August-2007 Status: Offline Points: 0	Post Options Post Reply Quote paulyork Report Post Thanks(0) Quote Reply Topic: Database file size? Posted: 09-April-2008 at 4:14pm
	I'm using v3.11 with MS Access. My site is at a point where it will not load. The Access file is over 9 megs, and that's with all products and orders removed. Is this normal to have a file this size?

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 09-April-2008 at 4:26pm
	9mb doesn't seem that large. Some will argue that it cannot be done but I actually have a hosting account running Access that is over 300mb. We are in the midst of migrating it to MSSQL, but size is not always an indication that an Access DB won't work. How much traffic are you getting? Could we a have a link please? BTW, if you decide to upsize to MSSQL, don't even think twice about going to Mark at Cogency. Just do it, to coin a phrase. He rocks.

paulyork Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 23-August-2007 Status: Offline Points: 0	Post Options Post Reply Quote paulyork Report Post Thanks(0) Quote Reply Posted: 09-April-2008 at 4:51pm
	The site is getting very little traffic, so I don't think it a "too many users" problem. The site is www.quiltsampler.com. The server seems to be OK. I have other site on this same server using the same version of PC with no problem.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 09-April-2008 at 5:09pm
	When it "finally" came up, there was a script timeout error in the "featured monthly closeouts" box. Without knowing what modifications have been done to the code, I'd be looking at that specific area first before assuming there was a database issue. Is a product active in that section? Does the script gracefully deal with the absence of a product being active in that section?