Database Size Question

General Forums General Questions
#1

Hello,



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?



Thanks.

#2

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

#3

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.



Thanks.

#4

Optimize the data base and clear the cache before upgrading.

#5

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/





www.webbeaver.net for more info

#6

Thanks everyone.

#7

customers>abandonded carts