Using ProductCart - Database file size?

Print Page | Close Window

Database file size?

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=1516
Printed Date: 27-November-2024 at 4:55am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Database file size?

Posted By: paulyork
Subject: Database file size?
Date 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?

Replies:

Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: paulyork
Date 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.

Posted By: Greg Dinger
Date 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?

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |