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

Bring2mind Forums

Forums > Document Exchange > Storage and Security
Speeding up Reset Szes script
Last Post 01/13/2012 3:17 PM by Peter Donker. 3 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Dearborn IT
New Member
New Member
Posts:22


--
12/29/2011 6:09 PM
Hi,

We currently have around 26000 files in our DMX installation and several thousand that have incorrect file sizes displayed. I've tried running the Reset Sizes script but it only does about 1400 files per hour. Is there a way to speed Reset Sizes script or run outside of DNN?
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
01/09/2012 11:10 AM
The process has two stages. The first stage actually looks at the size of the file. This takes time. The second stage does a readjustment of all the sizes in the database. You can try with just the SQL bit of this process:

EXEC {databaseOwner}{objectQualifier}DMX_ResetFolderSizes @PortalId

Peter
Dearborn IT
New Member
New Member
Posts:22


--
01/09/2012 4:07 PM
I will give EXEC {databaseOwner}{objectQualifier}DMX_ResetFolderSizes a try and see if that works out.

Is there any danger to updating the file sizes outside of DMX? I already have a utility I wrote that scans the retrieves all files from the database and compares the db reported size to the size as reported by the OS.
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
01/13/2012 3:17 PM
No, there is no danger. But note that there is a trigger on DMX_Entries to ensure the filesize remains correct. This trigger may block you from edits while it is running (deadlocks). You could optionally halt DMX and disable the trigger while you're doing your stuff. It's up to you.

Peter
You are not authorized to post a reply.
Forums > Document Exchange > Storage and Security
© 2024 Bring2mind Terms Of UsePrivacy Statement