Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

DMX_Log table over >500.000 records
Last Post 11/12/2012 9:12 AM by Peter Donker. 1 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Roel Broersma
New Member
New Member
Posts:1


--
11/05/2012 8:39 PM
Hello,

How can I truncate/purge the DMX_Log table? It's over 500.000 records which slows down and fills up my database.

I found another topic here: http://www.bring2mind.net...v/topic/Default.aspx but it is unanswered.

I understand there may be links/references to other tables.
The reason why the table is this big is because we do a SYNC every hour from our filesystem. In this way, we are sure that our website has all the files online that we have at our Filesystem.

Maybe there is a way to truncate only the not-used / unnecessary log items?

Kind regards,

Roel Broersma
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
11/12/2012 9:12 AM
Hi Roel,

You can delete what you want. There are no dependencies. Maybe you can create a SPROC out of it and call it at regular intervals.

Peter
You are not authorized to post a reply.