[SlimDevices: 3rd-party-hardware] Re: The point on SlimServer 6.5 and Linkstation II with Openlink

[miked98]

i compiled it with -O3 flags.  it took a few hours to run, but i think
if you look around the web, there are some additional optimizations you
could include that i did not.

for those of us running freelink on linkstations, i believe there are
several areas where slimserver could be improved to yield acceptable
performance -- in particular with the speed of MySQL queries and HTML
page-rendering.

one possible issue i see, based my naive knowledge of Slimserver but a
slightly more informed knowledge of MySQL, is that many of the most
frequently queried tables (for example the 'tracks' table) use 'text'
and 'blob' data types to store song title information.  more compact
summary tables, containing only char fields, would be much faster to
query, might speed up the response times (which even in my optimized
set-up can take a few seconds per page rendering).


-- 
miked98
------------------------------------------------------------------------
miked98's Profile: http://forums.slimdevices.com/member.php?userid=7531
View this thread: http://forums.slimdevices.com/showthread.php?t=28578