Coupons taking up major database space

mtgotraders · Post by **mtgotraders** » Fri Nov 02, 2007 6:42 pm

I have a lot of products and a lot of coupons so each coupon I create is taking up around 2mb's of space. Is there any way to program them so that they do not take up that much space in the database? I've also had to delete my older orders from the system just to free up space which should not be necessary.

(if shopsite used mysql there wouldn't be this problem)

mtgotraders · Post by **mtgotraders** » Fri Jul 04, 2008 2:08 pm

This is still a huge issue with my site and it's to there point where i'm going to have to get rid of a lot of my coupons just to "fix" this issue. The coupons are slowing down the upload of products substantially. Is there any fix on the horizon for this problem?

* A multiple codes for the same coupon patch would fix this issue and would be very easy for shopsite to implement. That way each group of people that have a coupon can still feel special with their unique code but the coupon would not kill our database.

mtgotraders · Post by **mtgotraders** » Mon Jul 07, 2008 6:25 am

What are the chances of getting a response to this?

mtgotraders · Post by **mtgotraders** » Thu Jul 17, 2008 2:08 pm

This problem has not gone away and is only getting worse. Any sort of response would be much appreciated. I have 2 shopsite pro stores yet can't get a reply to my simple question.

Post by **Jim** » Thu Jul 17, 2008 2:50 pm

The amount of space used by a coupon is not configurable. There is no option to create multiple coupon codes but still use just one coupon database record.

Have you tried the Compact database option to see if that will reduce the size of your database? If it doesn't and the database is too large, then the only option is to delete unused records from the database.

Note that this forum is a user forum not an official ShopSite support mechanism. When ShopSite employees answer question here they are not doing it as part of their job assignment.

mtgotraders · Post by **mtgotraders** » Fri Jul 18, 2008 11:54 am

Thanks for the response Jim.