pallfreeman wrote: > 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. :)
I run on windows. ------------------------------------------------------------------------ Jeff Flowerday's Profile: http://forums.slimdevices.com/member.php?userid=15883 View this thread: http://forums.slimdevices.com/showthread.php?t=96134 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/discuss