Database is growing fast. - Revindex - Forum

Forum

The forum is a free service supported by community members. Please consider opening a support ticket if you need timely help.

Prev Go to previous topic

Go to next topic

Last Post 26 Jul 2017 03:29 PM by Ton Hermes

Database is growing fast.

4 Replies

Sort:


You are not authorized to post a reply.

Author

Messages

Basic Member

Posts:281

20 Jul 2017 06:48 PM
Dear Stephen DNN 9.1.1. StoreFront 11.4 On my DNN install I have only installed storefront. There are +- 1000 products. There are +- 50 orders The database is 197 Mb now. Everyday is is growing with +- 2 Mb. I have truncate the exceptions table Empty the eventlog every day. Do you have any suggestion what this growing of the database is causing? Do you have a suggestion to get this database smaller? With regards, Ton

New Member

Posts:

24 Jul 2017 03:22 PM
just curious, have you checked your URL Logs? Are you using URL tracking?

Basic Member

Posts:281

24 Jul 2017 03:32 PM
Hi Phil, What is: - url tracking? - url logs? I'am not familiar with this. Can you explain this ? Regards, Ton

New Member

Posts:

24 Jul 2017 04:10 PM
if you don't know you're probably not using, but URL tracking is the DNN built-in ability to track the URL requests for each page and/or the clicks on individual modules. tracking the urls can easily grow the DB is the site gets a decent amount of traffic. It's a feature that can used to help identify what pages are getting most views, etc., but these most folks use Google Analytics instead..

Basic Member

Posts:281

26 Jul 2017 03:29 PM
Hi all, I found the problem ! The schedulehistory table took 150 Mb and was growing fast. I have truncate this table. Now the database is 60 Mb. In the past with former DNN (below 8 ?) you had to perform this job manually. With DNN 8 This job is automatically. Now, with DNN 9 this problem seem to be back again. Regards, Ton

You are not authorized to post a reply.