My Database is about 10 GB now. I have made a backup and it is 10 gb. How to make it less?

Hello.

I am using nopCommerce 3.90.

Just now I have seen that my DB is 10 GB in size! I have changed to file-system now. But before I created a backup.

My question is how to make the DB less?

Seems like my site kinda became faster when I changed to fyle-system...

PLEASE, HELP.

HOW TO MAKE THE DB SMALLER IN SIZE?

I have more than 1000 products!

zaf wrote:

1.Please remove all system log from log table.
2.Remove all guests customer from admin panel as well as db.
3.Remove all customers activity logs.


I think 1and 3 point might be helpful for you.

Thanks

nopSquare wrote:

Can you please explain how to do it in steps? :)

Where is the system log loacted?

Thanks.

zaf wrote:

Into database it's store under Log table.
And into administration side it's under system menu like below

http://youstoreurl/Admin/Log/List

Thanks

nopSquare wrote:

This one dbo.Log? I found this one dbo.Log.

Yes.

nopSquare wrote:

I don't know how to clean it(((

zaf wrote:

Run this below query.

Delete from dbo.Log

Thanks