Database Maintenance
Moderator: Gurus
Database Maintenance
My database is now 122 MB. To me, it seems big for a database.
Is there any maintenance that can or needs to be done on it to keep it small and healthy like (for example) Microsoft Access databases?
Or do I just carry on.... ?
Is there any maintenance that can or needs to be done on it to keep it small and healthy like (for example) Microsoft Access databases?
Or do I just carry on.... ?
Re: Database Maintenance
The easiest method i think most people use is...
File > Maintain Library > then make sure Optimize database (Complete) is ticked then OK it.
This should do a decent clean for you but the database size does get quite large depending on how albums etc you have.
File > Maintain Library > then make sure Optimize database (Complete) is ticked then OK it.
This should do a decent clean for you but the database size does get quite large depending on how albums etc you have.
Windows 10 Pro x64 2TB USB3 External Hdd with Quad Core 3600Mhz CPU and 10GB Ram
MM 4.1.21.1871 Portable on External Hdd
TESTING MM 5.0.0.2113
Numerous Addons
User Since 2006 (Lifetime License) since 2012
MM 4.1.21.1871 Portable on External Hdd
TESTING MM 5.0.0.2113
Numerous Addons
User Since 2006 (Lifetime License) since 2012
Re: Database Maintenance
As suggested, do the optimization on it periodically for the "health" part.
As far as the "size", no need to worry. MM can handle it
[122 MB is fairly small compared to many MM users]
As far as the "size", no need to worry. MM can handle it
[122 MB is fairly small compared to many MM users]
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
Re: Database Maintenance
Thanks guys.
I'll check that out.
I'll check that out.
Re: Database Maintenance
Microsoft Access <G> .. My db is approx 850m right now and that is middle of the road with this gang. There has been no problem from the db. Just do the maintenance as mentioned and do backups ..dypsis wrote:My database is now 122 MB. To me, it seems big for a database.
Is there any maintenance that can or needs to be done on it to keep it small and healthy like (for example) Microsoft Access databases?
Or do I just carry on.... ?
Where's the db and ini stored
Reporting Bugs
Where tags are stored
Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig
Reporting Bugs
Where tags are stored
Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig
Re: Database Maintenance
With all the information mm puts in the tags you must have 2000 songs
Re: Database Maintenance
Thanks guys.
I optimized the database. It didn't make any difference to the size though.
I optimized the database. It didn't make any difference to the size though.
Re: Database Maintenance
No surprise really. If you perform a pragma integrity check on an MM database after complete optimisation you'll probably find a load of missing references (that shouldn't be there). MM is the only SQLite database that I have which fails the test.I optimized the database. It didn't make any difference to the size though.
Re: Database Maintenance
It's not supposed to (that is significant enough to matter).dypsis wrote:I optimized the database. It didn't make any difference to the size though.
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
Re: Database Maintenance
From here:http://sqlite.org/lang_vacuum.htmlMMFrLife said: It's not supposed to (that is significant enough to matter).
"Unless SQLite is running in "auto_vacuum=FULL" mode, when a large amount of data is deleted from the database file it leaves behind empty space, or "free" database pages. This means the database file might be larger than strictly necessary. Running VACUUM to rebuild the database reclaims this space and reduces the size of the database file."
So are you saying that MediaMonkey's complete optimisation does not compact the database?
Re: Database Maintenance
The general idea of Optimization is to fix little inconsistencies that bog the database down from running smoothly.
Sure, it might compact it/reduce size some after also deleting empty space characters. But I don't think we're talking
differences of, say, from 122mb to 112mb or even 122mb to 117mb for most people (you might get those numbers
if you optimize (complete) after a few years of "frequently" deleting stuff from the database without any maintenance).
Have you or anyone else ever noticed a "significant enough" difference in size to matter much (size wise,
not overall database health) after doing an optimization and pre-optimization comparison test?
Sure, it might compact it/reduce size some after also deleting empty space characters. But I don't think we're talking
differences of, say, from 122mb to 112mb or even 122mb to 117mb for most people (you might get those numbers
if you optimize (complete) after a few years of "frequently" deleting stuff from the database without any maintenance).
Have you or anyone else ever noticed a "significant enough" difference in size to matter much (size wise,
not overall database health) after doing an optimization and pre-optimization comparison test?
MM user since 2003 (lifetime lic. 2012) "Trying to imagine life without music gives me a headache"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
Top 2 scripts: RegExp Find & Replace (e.v.) and Magic Nodes (e.v.) ZvezdanD's scripts site
Please take a moment to read the bottom of the linked page to support the one and only - ZvezdanD! (the "originator" since 2006).
MMW 4.1.31.1919; 5.0.4.2690 || back it up...frequently!
|| software for power users: "Q-Dir" (free alt. to explorer) and file/folder renamer: "ReNamer" (den4b)
"The absurd is the essential concept and the first truth"
Re: Database Maintenance
I am not concerned about the size of the database.
I just thought that I may have noticed a difference.
But, I am concerned of ensuring that it stays healthy.
I just thought that I may have noticed a difference.
But, I am concerned of ensuring that it stays healthy.
Re: Database Maintenance
And play dates are getting messed up.
Re: Database Maintenance
Can you clarify that?dypsis wrote:And play dates are getting messed up.
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts