Is this normal? (database size...)

I just upgraded from 2.0.7 to 2.0.12. Everything seems to be working fine. In fact, I’ve had a customer or two place a successful order since I reopened.



Database size before the upgrade was something like 140 MB.

Now it’s only 21 MB.



Did I lose a bunch of data or did it just get super optimized? :confused:



I had already deleted all my stats and logs… before then it was over 400 MB!!

Could be the cscart_stored_sessions table that was huge!! Mine was one quite huge at one point and caused problems with authentication for some reason. Then I empty the table and it was fine.


[quote name=‘ogia’]I just upgraded from 2.0.7 to 2.0.12. Everything seems to be working fine. In fact, I’ve had a customer or two place a successful order since I reopened.



Database size before the upgrade was something like 140 MB.

Now it’s only 21 MB.



Did I lose a bunch of data or did it just get super optimized? :confused:



I had already deleted all my stats and logs… before then it was over 400 MB!![/QUOTE]

Glad to hear you made it to 2.0.12 Ogia! :wink:



A good deal of the extra db size was probably related to the sessions table. They have also made several optimization changes along the way up to 2.0.12.



PS: What all did you end up having to do to get to 2.0.12 ?

I guess I’ll have to watch the sessions table. :eek:



I ended up using the built-in upgrade. I just had tooo much data to work with on my computer. I also tried using localhost and the data was getting truncated and/or processes were timing out. CS-Cart staff replied to my support ticket that they’d “upgraded” my test store, but I couldn’t even log into the admin panel due to all the database errors. I suspect the database was truncated in that case too.



I finally determined why I couldn’t upgrade on my server… my installation directory had been renamed :oops: Duh. Once I fixed that and got my database optimized it was smooth sailing.