I probably should have included more information about my setup:
Total Tracks: 12,660
Total Albums: 1,022
Total Artists: 465
Total Genres: 1,794
AMD Athlon(tm) 64 X2 Dual Core Processor 5000+
squeezeboxserver 7.5.0
Ubuntu 9.10 (64bit)
--
SuperQ
--
Moving things into a ram disk will not help database queries take less
time. The way Linux works is to copy any disk data into ram for use,
and then keep it there until the system is out of memory for new data.
This is called "page cache"
Here is an example of the "free" command output on my ma
yeah the default values for the SBS provided mysql are a bit spartan as
it have to fit the lowest determinator : a NAS.
Time will tell how SQLite will perform with complex queries but at
least one can switch to mysql if needed.
--
slate
Main: Duet -> Beresford Caiman -> Carver A-500x -> B&W 7
slate;532992 Wrote:
> Otherwise, if you are using the mysql that comes with SBS, you can use
> better settings for mysql; see
> http://forums.slimdevices.com/showthread.php?t=60682
> In post 18 you find a configuration file that can be used.
Cool, that helps. More complex queries are much quick
adamslim wrote:
> It's just the web interface, and especially when I'm doing more complex
> stuff with custom browse. Some of the database queries can take over
> 20-30s, and since I would like to run several queries (for example,
> first to get piano music, then instrumental rather than orchestra
A ramdisk can make things move along; there is a user here that does
that... try search.
Otherwise, if you are using the mysql that comes with SBS, you can use
better settings for mysql; see
http://forums.slimdevices.com/showthread.php?t=60682
In post 18 you find a configuration file that can be
It's just the web interface, and especially when I'm doing more complex
stuff with custom browse. Some of the database queries can take over
20-30s, and since I would like to run several queries (for example,
first to get piano music, then instrumental rather than orchestral), it
makes the whole
adamslim wrote:
> I would like to speed up the web interface and database queries, and
> wondered if moving some files to a ramdisk would help. (The machine is
> quite fast - Core2Duo, 4GB RAM, used only as a server and on 24/7).
RAMdisk is rarely useful on modern OS, such as Ubuntu 9.10. Using o
I've just migrated to Linux (Ubuntu 9.10) for SBS, and know next to
nothing about how Linus works - so clear explanations needed please!
I would like to speed up the web interface and database queries, and
wondered if moving some files to a ramdisk would help. (The machine is
quite fast - Core2D