FireFly Media Server (formerly mt-daapd) › Firefly Media Server Forums › Firefly Media Server › General Discussion › ‘idx’ and ‘disable’ fields in database › Reply To: ‘idx’ and ‘disable’ fields in database
Each (proper) database needs an primary key, for firefly’s song-db this is the field called “idx”.
One index uniquely identifies an mp3.
Normally, this is linked to a sequence, so that any inserts should youse NEXTVAL (or similiar) from that sequence to populate the songs.idx field.
Also, and index greatly increases performance on said fields.
select * from songs where idx=1232;
doesnt do a full table scan, for instance 😉