Large Playlist (16625 entries) gets very slow usingn mysql

[Siegfried Wolkenstein]

Ok. But why can't one make huge playlists faster? It shouldn't be a problem.

On Friday 11 July 2008 12:19:45 Rich wrote:
> 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