X-Git-Url: http://git.tuebingen.mpg.de/?a=blobdiff_plain;f=web%2Fmanual.md;h=15386134771c2921ecf840347e8179aecc374e1a;hb=67cb641c126769af98289539ff3425dfbf5e12e2;hp=43509f129237246265f3644cdf93bc776bd9a1cc;hpb=33ba8eb22b343a76c455bb240fbbfd3dc3063f11;p=paraslash.git diff --git a/web/manual.md b/web/manual.md index 43509f12..15386134 100644 --- a/web/manual.md +++ b/web/manual.md @@ -754,8 +754,8 @@ these commands. The image, lyrics, moods and playlists tables are all blob tables. Blob tables consist of three columns each: The identifier which is -a positive non-negative number that is auto-incremented, the name -(an arbitrary string) and the content (the blob). +a positive number that is auto-incremented, the name (an arbitrary +string) and the content (the blob). All blob tables support the same set of actions: cat, ls, mv, rm and add. Of course, _add_ is used for adding new blobs to the table @@ -779,21 +779,19 @@ or playlist is activated with the select command. ### The score table ### -Unlike all other tables the contents of the score table remain in -memory and are never stored on disk. The score table contains two -columns: The SHA1 hash value (of an audio file) and its current -score. +The score table describes those audio files which are admissible for +the current mood or playlist (see below). The table has two columns: +a pointer to a row of the audio file table and a score value. -However, only those files which are admissible for the current mood -or playlist are contained in the score table. The audio file selector -always chooses the row with the highest score as the file to stream -next. While doing so, it computes the new score and updates the -last_played and the num_played fields in the audio file table. - -The score table is recomputed by the select command which loads a -mood or playlist. Audio files are chosen for streaming from the rows -of the score table on a highest-score-first basis. +Unlike all other tables of the database, the score table remains in +memory and is never stored on disk. It is initialized at startup and +recomputed when the select command loads a new mood or playlist. +When the audio file selector is asked to open the next audio file, +it picks the row with the highest score, opens the corresponding +file and passes the file descriptor to the virtual streaming system. +At this point the last_played and the num_played fields of the selected +file are updated and the score is recomputed. Playlists and moods -------------------