Large Playlist (16625 entries) gets very slow usingn mysql

[Rich]

On 2008.07.11. 12:57, Siegfried Wolkenstein wrote:
> I am talking about the playlist. I like to have my whole collection in one 
> playlist.

well, that wouldn't work with amarok too well.
i'd suggest following this walkthrough here - 
http://amarok.kde.org/wiki/Dynamic_Playlist_Walkthrough

try to use such a playlist for a week or two, and you'll appreciate both 
the powerful capabilities of smart/dynamic playlists & small playlist ;)

for searching, use collection browser - it should be MUCH faster.

> i ran the mysqltuner and did what it suggested -> no improvement though.
> 
> On Friday 11 July 2008 11:19:36 Dr. Diesel wrote:
>> Are you saying your collection has 16k entries?  Or an actual saved
>> playlist?
>>
>> My collection has 150k songs, searching takes about 1 second to load
>> the matches.  You could try the mysqltuner Perl script, it does some
>> basic checking of your mysql config.
>>
>> On Fri, Jul 11, 2008 at 5:08 AM, Siegfried Wolkenstein
>>
>> <rough_rough at gmx.de> wrote:
>>> Hello,
>>>
>>> it seems to me that amarok very often scans the whole musicdirectory
>>> recursively simply to play the next random song. I've switched off the
>>> option "watch folders for changes". What else can I do to make this
>>> faster?
>>>
>>> Also when I search the playlist and try to play a song by double clicking
>>> on it, as soon as the search result appears, it takes ages till I hear
>>> something (I can hear the hard drive searching and searching and I ask
>>> myself why).
>>>
>>> Thank you
>>>
>>> Amarok 1.4.9.1 using KDE 3.5.9 release 65.1 openSuSE 10.2
-- 
  Rich