home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 2
General
MP2-Edit - A MediaPortal 2 Media Library Editor
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Lehmden" data-source="post: 1141730" data-attributes="member: 109222"><p>Hi.</p><p>I'm using an "UDF" (User Defined Function) in AutoIt to do the backup. You can call those functions with various options and the function is "talking" with SQLite. So the program itself did not need to do this. Not much difference to a DLL- call, I think. One of those options is the "block size" to do the backup. Default this is small so the backup process needs a lot of attempts to do a complete backup- And as the time between those attempts (iSleepTime) are "some eternities" in computer timing the backup needs some hours for me. For a test I've set this page size to "-1" what means "Backup the Database in one Attempt". Now the backup is done in less than one minute here (1.2 GB Datastore.s3db and 25 MB MP2TVE_3.s3db. backed up from system SSD to a different internal HDD) . And also I've tried hard I can't get any disadvantages. No dropouts in running TV Recordings or hickups in MP2 GUI or similar. Only thing I didn't try up to now is to trigger a backup while an import is running...</p><p></p><p>Here is the code line I've changed for this:</p><p>"Func _SQLite_Backup($hSrcDbCon, $sDstDbFile, $sSrcDbName = Default, $sDstDbName = Default, $iBlockSize = -1, $iSleepTime = Default, $hProgressBar = Default)"</p><p>The option $iBlockSize was set to "Default" like all others in previous versions of the backup tool...</p></blockquote><p></p>
[QUOTE="Lehmden, post: 1141730, member: 109222"] Hi. I'm using an "UDF" (User Defined Function) in AutoIt to do the backup. You can call those functions with various options and the function is "talking" with SQLite. So the program itself did not need to do this. Not much difference to a DLL- call, I think. One of those options is the "block size" to do the backup. Default this is small so the backup process needs a lot of attempts to do a complete backup- And as the time between those attempts (iSleepTime) are "some eternities" in computer timing the backup needs some hours for me. For a test I've set this page size to "-1" what means "Backup the Database in one Attempt". Now the backup is done in less than one minute here (1.2 GB Datastore.s3db and 25 MB MP2TVE_3.s3db. backed up from system SSD to a different internal HDD) . And also I've tried hard I can't get any disadvantages. No dropouts in running TV Recordings or hickups in MP2 GUI or similar. Only thing I didn't try up to now is to trigger a backup while an import is running... Here is the code line I've changed for this: "Func _SQLite_Backup($hSrcDbCon, $sDstDbFile, $sSrcDbName = Default, $sDstDbName = Default, $iBlockSize = -1, $iSleepTime = Default, $hProgressBar = Default)" The option $iBlockSize was set to "Default" like all others in previous versions of the backup tool... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
General
MP2-Edit - A MediaPortal 2 Media Library Editor
Contact us
RSS
Top
Bottom