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/16/2016 7:07 PM
 
Mark - Cart Viper Developer
7th Level Poster


Joined: 7/27/2010
Posts: 424
Hi

Glad to be of help.

Regards

Mark
 
New Post
7/18/2017 8:05 PM
 
Yankee516
No Ranking

Joined: 8/22/2011
Posts: 9

Thank you for your previous help. We had to upgrade DNN due to a recent security vulnerability and also had to upgrade CV from v1.6.1 to v3.7.1. I've run the cleanup scripts mentioned in this thread, but my OrderAttributes table is pretty huge at 107MB. We're limited to a 200MB db at the hosting company. Any ideas on what we can do to reduce the size of this table?

TableName SchemaName RowCounts TotalSpaceKB TotalSpaceMB UsedSpaceKB UsedSpaceMB UnusedSpaceKB UnusedSpaceMB
CVStore_OrderAttributes dbo 203649 110360 107.77 110240 107.66 120 0.12
CVStore_Addresses dbo 17346 5576 5.45 5528 5.4 48 0.05
CVStore_OrderDetails dbo 11787 3464 3.38 3432 3.35 32 0.03
CVStore_Audit dbo 8230 2016 1.97 1952 1.91 64 0.06
CVStore_OrderDetailsAttributes dbo 2282 1936 1.89 1888 1.84 48 0.05
CVStore_Orders dbo 9736 1416 1.38 1416 1.38 0 0
CVStore_User_Product_List_Categories dbo 2759 728 0.71 616 0.6 112 0.11
CVStore_Products dbo 87 432 0.42 184 0.18 248 0.24
CVStore_ProductAttributes dbo 2838 336 0.33 312 0.3 24 0.02
CVStore_Categories dbo 19 288 0.28 64 0.06 224 0.22
CVStore_Cart dbo 0 272 0.27 64 0.06 208 0.2
CVStore_CategoryProduct dbo 84 216 0.21 48 0.05 168 0.16
CVStore_CartItemsAttributes dbo 0 144 0.14 32 0.03 112 0.11
CVStore_Administration dbo 1 144 0.14 32 0.03 112 0.11
CVStore_ProductImages dbo 79 144 0.14 48 0.05 96 0.09
CVStore_ProductVariant dbo 31 144 0.14 32 0.03 112 0.11
CVStore_UserProductList dbo 503 144 0.14 56 0.05 88 0.09
CVStore_StoreAttributes dbo 138 144 0.14 56 0.05 88 0.09
CVStore_ProductVariantOption dbo 71 144 0.14 32 0.03 112 0.11
CVStore_WidgetModule dbo 1 144 0.14 32 0.03 112 0.11
CVStore_WidgetTemplate dbo 1 144 0.14 32 0.03 112 0.11
CVStore_ShippingRates dbo 1 72 0.07 16 0.02 56 0.05
CVStore_ProductVisualizer dbo 1 72 0.07 16 0.02 56 0.05
CVStore_CartItems dbo 0 72 0.07 16 0.02 56 0.05
CVStore_License dbo 1 72 0.07 16 0.02 56 0.05
CVStore_EUCountries dbo 28 72 0.07 16 0.02 56 0.05
CVStore_FacetSearchCategories dbo 0 0 0 0 0 0 0
CVStore_FacetSearchItem dbo 0 0 0 0 0 0 0
CVStore_FacetSearchProducts dbo 0 0 0 0 0 0 0
CVStore_FacetSearchValues dbo 0 0 0 0 0 0 0
CVStore_FreeProduct dbo 0 0 0 0 0 0 0
CVStore_FreeShipping dbo 0 0 0 0 0 0 0
CVStore_Gift_Certificate_Group dbo 0 0 0 0 0 0 0
CVStore_Gift_Certificate_Numbers dbo 0 0 0 0 0 0 0
CVStore_InStorePickupLocation dbo 0 0 0 0 0 0 0
CVStore_License2 dbo 0 0 0 0 0 0 0
CVStore_MixMatch dbo 0 0 0 0 0 0 0
CVStore_MixMatchCategory dbo 0 0 0 0 0 0 0
CVStore_NewsLetterUsers dbo 0 0 0 0 0 0 0
CVStore_OrderFreeProduct dbo 0 0 0 0 0 0 0
CVStore_OrderNumberSequence dbo 0 0 0 0 0 0 0
CVStore_CartAttributes dbo 0 0 0 0 0 0 0
CVStore_CardSaveRecurringPayment dbo 0 0 0 0 0 0 0
CVStore_CategoryRedirect dbo 0 0 0 0 0 0 0
CVStore_CategoryYouTubeVideos dbo 0 0 0 0 0 0 0
CVStore_ChangeSet dbo 0 0 0 0 0 0 0
CVStore_ChangeSetItem dbo 0 0 0 0 0 0 0
CVStore_CheckoutStateStore dbo 0 0 0 0 0 0 0
CVStore_Coupons dbo 0 0 0 0 0 0 0
CVStore_Donation_Amounts dbo 0 0 0 0 0 0 0
CVStore_ProductVisualizerMarkers dbo 0 0 0 0 0 0 0
CVStore_ProductYouTubeVideos dbo 0 0 0 0 0 0 0
CVStore_QtyDiscountBand dbo 0 0 0 0 0 0 0
CVStore_QuoteExport dbo 0 0 0 0 0 0 0
CVStore_QuoteImport dbo 0 0 0 0 0 0 0
CVStore_RecurringOffer dbo 0 0 0 0 0 0 0
CVStore_RestrictiveShippingDates dbo 0 0 0 0 0 0 0
CVStore_Reviews dbo 0 0 0 0 0 0 0
CVStore_Shipping_ProductRates dbo 0 0 0 0 0 0 0
CVStore_StoreInstance dbo 0 0 0 0 0 0 0
CVStore_StoreLanguage dbo 0 0 0 0 0 0 0
CVStore_StorePromotions dbo 0 0 0 0 0 0 0
CVStore_Supplier dbo 0 0 0 0 0 0 0
CVStore_USA_STATE_COUNTY_TAX dbo 0 0 0 0 0 0 0
CVStore_UserRegistrationCode dbo 0 0 0 0 0 0 0
CVStore_UserAbandondedCartEmailSent dbo 0 0 0 0 0 0 0
CVStore_UserHierarchy dbo 0 0 0 0 0 0 0
CVStore_ProductVariantInventoryManagement dbo 0 0 0 0 0 0 0
CVStore_ProductVariantInventoryManagementProductVariantOptionIds dbo 0 0 0 0 0 0 0
CVStore_ProductRedirect dbo 0 0 0 0 0 0 0
CVStore_ProductSerialNumbers dbo 0 0 0 0 0 0 0
CVStore_ProductTabs dbo 0 0 0 0 0 0 0
CVStore_ProductUserPricing dbo 0 0 0 0 0 0 0
CVStore_CategoryAttributes dbo 0 0 0 0 0 0 0
CVStore_ProductDigitalDownload dbo 0 0 0 0 0 0 0
CVStore_ProductDnnRoles dbo 0 0 0 0 0 0 0
CVStore_OrderStatusesCustom dbo 0 0 0 0 0 0 0
CVStore_Product_Discount_Bundles dbo 0 0 0 0 0 0 0
CVStore_ProductAccordionLeaf dbo 0 0 0 0 0 0 0
CVStore_Zip2Tax dbo 0 0 0 0 0 0 0
CVStore_ZipCodeShippingBand dbo 0 0 0 0 0 0 0
 
New Post
7/19/2017 11:51 AM
 
Nigel - Cart Viper Developer
4th Level Poster


Joined: 7/27/2010
Posts: 789
Hi,

Unless you want to delete historic orders from your site this isnt really a table you can look to reduce in size as all the data in here relates to orders within your site and if you delete
data from it they will not load correctly in the store admin.

Regards
 
New Post
7/19/2017 12:51 PM
 
Mark - Cart Viper Developer
7th Level Poster


Joined: 7/27/2010
Posts: 424
Hi 

What you could do is run this query, I would guess you'll have a lot of log entries in the order attribute table. 

select name, count(name) from CVStore_OrderAttributes
  group by name
  order by count(name) desc

These are used in case you have an issue placing an order and will be invaluable in debugging any issue.

However if your orders are all placed successfully you might be able to free up space by deleting the entries with the name="CV_STORE_ORDER_LOGGING"

Regards

Mark
 
 Page 2 of 2
Previous12 
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