Database Size Question


I have a low activity store with about 1000 products. The cs cart store is about 3 years old. My database has grown for 44MB which seems a little high. The table cscart_stored_sessions has 11,500 rows as is 11.5 MB. The next largest table is orders which I'll leave alone. Then comes cscart_sessions at 88 rows and 4.8 MB.

Can I safely truncate cscart_stored_sessions and cscart_sessions?


Hi, what is your cs-cart version? 44MB is not large and it's better to not truncate those two tables.

I'm running 4.1.4 planning to upgrade to 4.2x once it is stable. I've had troubles with the past upgrades where the upgrade would fail mid stream and I had to revert back. The second attempt always worked. I thought I'd try cleaning up the database first before I tried again.


Optimize the data base and clear the cache before upgrading.

Hi, novista

I would like to update some points about this;

[color=#282828][font=arial, verdana, tahoma, sans-serif]1.I think this table holds user carts, it would not be good idea to clear it all. [/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif]2.clearing and deleting are different regarding the tables.[/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif]3. regarding truncateing "[/font][/color][color=#000000][size=2]TRUNCATE cscart_stored_sessions[/size][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]Enter this in the 'sql' tab[/size][/font][/color]

[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]more info.[/size][/font][/color]

http://forum.cs-cart…tored-sessions/ for more info

Thanks everyone.

customers>abandonded carts