Jeff Flowerday wrote: 
> I have 110,000+ tracks and I was forced to used a ramdisk for the cache
> and database.  But LMS has been working very well since implementing it.

I'm something of an obsessive performance geek when I get the time. I've
tried ZFS in the NAS, adding SSDs to the ZFS, using 15K "enterprise"
disks with a caching controller; using an SSD in the LMS box, an
additional jumbo-framed SAN, and running LMS on CPUs way too powerful.
Amongst other things. All a waste of time and money.

With dbhighmem enabled, what made the biggest difference to performance
for me is this:

push @{$sql}, 'PRAGMA cache_size = 2000000';

in Utils/SQLiteHelper.pm.

FFS. :)


------------------------------------------------------------------------
pallfreeman's Profile: http://forums.slimdevices.com/member.php?userid=37667
View this thread: http://forums.slimdevices.com/showthread.php?t=96134

_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss

Reply via email to