onepage_moss table size

Please post your questions and problems with any of our extensions which you are using

onepage_moss table size

Postby gestion@.....com » Sun Jan 01, 2017 7:57 am

Hi Stan

While checking database noticed the table for onepage_moss was like 30 MB, could that be correct?

Regards
gestion@.....com
 
Posts: 127
Joined: Wed Feb 13, 2013 1:34 pm

Re: onepage_moss table size

Postby admin » Wed Jan 04, 2017 4:01 pm

hello, yes, it could be since it stores any data for as "tax proof" for the address and the VAT rate, maybe i could add an "archive" logic so that it copies old data into an "archive table".

can you pls check if it includes any data that you'd find not useful, generally it stores:
- any VAT ID attempts to validate the EU VAT number so you could track what sort of problems the customer could had had and what is the history of the validation or vies service status
- any IP or address related information to the tax proofs (IP to Geographical location)
- tax data to differentiate different tax cases
- serialized/json data for the current price object at the cart,which can be deserialized and re-calculated later if needed (VM stores some of this data in it's order tables, but not a full results of the calculation)

best regards, stan
admin
Site Admin
 
Posts: 2708
Joined: Wed Jan 06, 2010 11:43 pm


Return to VirtueMart and Joomla Extensions (free or paid)