Coupons taking up major database space

[mtgotraders]

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]

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]

What are the chances of getting a response to this?

[mtgotraders]

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.

[Jim]

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]

Thanks for the response Jim.