Running Databases from RAM (1 Viewer)

[m.standish]

Im trying to speed MP up (mainly DB showing) as ive got 26,00 songs
Ive managed to get quite a large increace by copying the databases to a virtual ram drive and changing the DB path.
Ive got a batch file to copy them on boot but i cant find a way to save them back either on shutdown or MP close <preffered
I wouldnt be too bothered but the tv & film DB isnt going to update
Does anyone have any ideas?

 

[reagan+carter]

great idea

what kind of flash file system do you use? and how did you manage to modify the DB directories (soft-links?)?

 

[Roberdin]

Surely it would be easier just to reconfigure MS SQL Server 2005 to cache the database in RAM? I'm sure this can be done, possibly by changing the profile of the SQL server?

 

[rtv]

boot but i cant find a way to save them back either on shutdown or MP close <preffered

Check the group policies "gpedit.msc"
There you'll find logon and logoff scripts - add your batchfile which saves the cached DB back to disk in there. Worked nicely here. Also re-locate your thumbs folder to the ramdisk - should be good for another large speedup.

 

[reagan+carter]

hello everyone

rtv or m.standish can you please explain how you could possibly achieve this trick

 

[rtv]

The simple search here got that link:
https://forum.team-mediaportal.com/showthread.php?t=1807&highlight=ramdisk
A detailed step by step how-to inside

 

[m.standish]

And theyer i thought i was being original!
Problem with the thumbs as theyre too large (till i add another GB), tried it already but cheers (370MB)
I cant use GPedit as ive got a nlited install, is there another way??


I used tweak xp`s ramdisk function to create a 100mb ramdrive r:
create a batch file to copy the databases to ram (r
edit mediportaldirs.xml
point the db section to r:

follow the above post to copy them back on shutdown else and updates to the db will not be saved.

 

[idioteque]

try putting the batch file in task schedular to run every few hours or minutes

 

[m.standish]

Lovely idea!
Recon every 2 hours should do the trick
Thanks 4 that

 

[m.standish]

here are my batchfiles if theyre any use to anyone
(d: is my boot, r: is my virtual ram drive)

TIP1. put the copyto as a startup item and disable MP autostarting in config. this way the DB`s are guranteed to be in ram before MP calls for em, else things get kinda messy when MP has no databses!! lol

TIP2. dont call the batchfile copy.bat cos when your trying to test it in dos it really causes problems, anyone spot my booboo!! Oh how silly do i feel!
invalid argument, invalid argument, invalid argument, invalid argument, invalid argument. WHAT THE!..................................ah..........................woops!