Page 1 of 1

onepage_moss table size

PostPosted: 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?


Re: onepage_moss table size

PostPosted: Wed Jan 04, 2017 4:01 pm
by admin
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