Cart Viper Logo

We understand that your ecommerce site is crucial to the success of your business, from time to time issues and questions can arise and you need to have the assurance there will be someone on hand to help resolve these in a timely fashion so you can spend your time driving your own business forward.

So if you are looking for faster responses to your questions or would like the assurance there is someone on hand for you to contact, fear not we have a number of paid support options that are available to you that can give your organisation the peace of mind knowing a member from the Cart Viper team will always be available to assist!

Purchase a Support Plan

Community Support

HomeHomeIssues and Supp...Issues and Supp...MiscellaneousMiscellaneousCVStore_OrderAttributes tableCVStore_OrderAttributes table
Previous
 
Next
New Post
9/15/2016 7:05 PM
 
Yankee516
No Ranking

Joined: 8/22/2011
Posts: 9
My client has been running CV v1.6.1 for quire some time now. Problem is that the database has reached the hosting company's limit of 200MB.

I noticed that the CVStore_OrderAttributes is taking up about 25% of the space in the database. The data in it doesn't seem to even be accessible anywhere in the UI from what I can tell.

Is it safe to delete old or all data to clear space...
 
New Post
9/15/2016 8:42 PM
 
Mark - Cart Viper Developer
7th Level Poster


Joined: 7/27/2010
Posts: 424
Hi

No don't delete that table, the attributes tables are important and hold important information that is surfaced in the UI.

What I would is run this script (you'll need to run this from SQL Management Studio, it might not execute in the host > SQL page). 

https://gist.github.com/markmcavoy/f2...

This will tell you which tables are taking the space once you have run the script please provide me with the results and I'll help point you in the correct direction.

Regards

Mark
 
New Post
9/15/2016 8:52 PM
 
Yankee516
No Ranking

Joined: 8/22/2011
Posts: 9
I had run a similar query to get the info. As a temporary fix I shortened the length of the [name] column from 512 to 50 in the CVStore_OrderAttributes table since the max length was only 34. Seems to be an awful waste of space:

Table_Name rows reserved_KB data_KB index_size_KB unused_KB
CVStore_Cart 191617 54736 KB 30440 KB 24200 KB 96 KB
CVStore_OrderAttributes 145583 47632 KB 45288 KB 2216 KB 128 KB
CVStore_User_Product_List 227369 27352 KB 12952 KB 14192 KB 208 KB
UserProfile 27759 4824 KB 1568 KB 2024 KB 1232 KB
aspnet_Membership 4139 4432 KB 3256 KB 824 KB 352 KB
FolderPermission 5557 3720 KB 432 KB 1832 KB 1456 KB
CVStore_Addresses 12559 3592 KB 3496 KB 16 KB 80 KB
CVStore_Audit 8230 2208 KB 1264 KB 496 KB 448 KB
aspnet_Users 4139 2136 KB 800 KB 1000 KB 336 KB
Users 2094 2024 KB 752 KB 712 KB 560 KB
CVStore_CartItemsAttribut 4686 1424 KB 1008 KB 152 KB 264 KB
CVStore_OrderDetails 8315 1352 KB 1216 KB 16 KB 120 KB
Files 71 1064 KB 56 KB 216 KB 792 KB
UserRoles 2095 984 KB 312 KB 256 KB 416 KB
CVStore_OrderDetailsAttri 1816 912 KB 624 KB 64 KB 224 KB
Folders 1179 856 KB 216 KB 248 KB 392 KB
TabModules 161 800 KB 72 KB 120 KB 608 KB
CVStore_Orders 7122 712 KB 536 KB 16 KB 160 KB
CVStore_ProductAttributes 2442 592 KB 256 KB 72 KB 264 KB
Tabs 74 560 KB 64 KB 96 KB 400 KB
TabPermission 112 560 KB 24 KB 112 KB 424 KB
Lists 358 544 KB 40 KB 104 KB 400 KB
UserPortals 1297 536 KB 160 KB 112 KB 264 KB
Feedback 113 528 KB 176 KB 48 KB 304 KB
ModulePermission 64 488 KB 16 KB 96 KB 376 KB


I think we are going to move the database to the cloud anyway since 200 MB pretty restrictive these days.
 
New Post
9/16/2016 9:53 AM
 
Mark - Cart Viper Developer
7th Level Poster


Joined: 7/27/2010
Posts: 424
Hi

I would run these two queries to clean up the database

delete
FROM [CVStore_User_Product_List_Categories]
where anonymousId is not null
go


DELETE FROM [CVStore_CartItems]
DELETE FROM [CVStore_Cart]
go

Once you have done that then shrink the database using SQL Management Studio and that should free up some space.

Regards

Mark
 
New Post
9/16/2016 4:49 PM
 
Yankee516
No Ranking

Joined: 8/22/2011
Posts: 9
WOW! That brought the database down by 75MB, a 30% gain in available space!

Thank you SO much for this! I'll probably have to do this as a part of our regular maintenance routine.

Cheers!
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeIssues and Supp...Issues and Supp...MiscellaneousMiscellaneousCVStore_OrderAttributes tableCVStore_OrderAttributes table


 

We use cookies on our website to improve our service to you, by continuing you agree to our use of cookies. However you are able to update your settings at any time.

Continue View Cookie Policy Cookie Settings

Cookie Policy

A cookie, also known as an HTTP cookie, web cookie, or browser cookie, is a piece of data stored by a website within a browser, and then subsequently sent back to the same website by the browser. Cookies were designed to be a reliable mechanism for websites to remember things that a browser had done there in the past, which can include having clicked particular buttons, logging in, or having read pages on that site months or years ago.

Strictly Necessary Cookies

These cookies cannot be disabled

These cookies are necessary for the website to function and cannot be switched off. They are normally set in response to your interactions on the website e.g. logging in etc.

Cookies:
  • .ASPXANONYMOUS
  • .DOTNETNUKE
  • __RequestVerificationToken
  • authentication
  • CV_Portal
  • CV_Store_Portal_Cart_0
  • CV_USER
  • dnn_IsMobile
  • language
  • LastPageId
  • NADevGDPRCookieConsent_portal_0
  • userBrowsingCookie

Performance Cookies

These cookies allow us to monitor traffic to our website so we can improve the performance and content of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited or how you navigated around our website.

Cookies:
  • _ga
  • _gat
  • _gid

Functional Cookies

These cookies enable the website to provide enhanced functionality and content. They may be set by the website or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookies:

Currently we are not utilizing these types of cookies on our site.

Feedback