Generating a single hour takes very long in V6

I noticed that it takes a long time to generate a single (hour) playlist in the Database in V6: Database - Playlist - Generate - Choose a Hour Template - Choose a Music Template.
In V5 it takes less than 10 seconds to generate one hour, in V6 it takes me 1 minute and 25 seconds. After 1 minute a message appears “The application seems to be frozen”.
Could you have a look at this Torben? (I’m currently on v6 - 3527)

I also noticed that generating playlists take longer as usual.

mAirList 5 fetched only the basic item information (ID, artist/title, last play) for all folders initially, then loaded the details one by one.

mAirList 6 loads all item details right away.

As a result, generating a single list will be slower, but generating many playlists in a row will be much quicker.

Oh, maybe you can send me a copy of your database file to check if there is another bottleneck?

With my demo/development database, it has become a bit slower, but not THAT slow.

I’ve send you a link to my database file by e-mail Torben.

Edit: I just tried to generate 24/7 playlists for one week and after 10 minutes only 16 out of 168 playlists have been generated. The message “the application seems to be frozen” keeps popping up.

Try build 3528 please, should be much quicker.

Another tip to speed up the process: Do not use a huge “Unsorted” folder with lots of attribute filters. Instead, make some new folders, and do not use attribute filters unless absolutely necessary.

Build 3528 is much quicker now Torben, in my case (with unchanged “Unsorted” folder) it’s more or less the same speed as it is in V5, which is fine with me.

Let me explain why I’m using a big unsorted folder: if I was to use folders for the 90’s, 80’s and so on, every song picked from that folder will be an 80’s or 90’s song. Sometimes I don’t want to be that predictable, so I’m leaving out the attribute for the decades, resulting in a picked song that could be from all decades.

As it is now, with build 3528, I’m more than satisfied! Thanks!

Here it still takes 25 minutes to generate an playlist for a week.
Must confess, I use different attributes, the Unsorted folder only has 90 items.

You can enable the debug log during scheduling (maybe not for an entire week but only for a day or so) and send me the output so I can check where the bottleneck is. The new snapshot adds timestamps to the log output now.

Actually I’d expect v6 to be much faster when using attributes, as all items with all attributes are fetched at once when the folder is first used. In v5, only the IDs are fetched, and the attributes are fetched later (for each playlist item, one by one) when a filter is encountered.

To those who think they need attribute filters to make a random selection of genres: Have you checked if maybe “include subfolders” (in the settings of a folder entry in the music block config) is a solution?

I found the bottleneck here.
Got a virtual folder Archive, It is then split into 60’s to 010’s.
As we only do mostly 60, 70 and 80’s the others can be ignored.

I now have defined the wanted folders in the Music blocks.
Reducing the time to 6 minutes :slight_smile:

One other thing, the option to remember the choice to overwrite existing playlists is not being remembered.

Regards,
Ferry

Still, for some reason I believe the “old way” wasn’t too bad after all. So why fix it when it’s not broken? :wink: It took me only a couple of minutes to generate a weekly playlist and permitted me some time for a cup of coffee :wink:

When I have to rearrange my entire folder structure, I have to change all my Music Templates and perhaps change some of the attributes of all my songs (> 20.000) :-\

New build 3529 should be even faster; also fixes a bug in the calculation of penalties/separations.

what is New build 3529, what i have to change for that?
I Didn t understand everything
thanks for the help

I made some optimizations and fixed some bugs. Just install on top.

install what?

The latest build: http://download.mairlist.com/mAirList/v6.0/snapshot/

Guess the new Snapshot (Build 3534)

what is New build 3529 ?
new version without bugs?
did you fix french translation for planification?
for live, searching files are slow compare to version 5

Just read the Release notes.txt
Every change is in there.

I ve read, after having the link
thanks