Hello again, I am quite new at database and how to set them up properly so keep in mind that the obvious might stare into your face but just point it out to me :-)
I am having this database with mediafiles (even anyone recall my previous mails) and I create it like this: CREATE TABLE Files (path VARCHAR(255) PRIMARY KEY, title VARCHAR(255), artist VARCHAR(255), album VARCHAR(255), genre VARCHAR(255), comment VARCHAR(255), track INTEGER, year INTEGER, length INTEGER, bitrate INTEGER, playcount INTEGER, changed INTEGER, size INTEGER, tagged INTEGER, extension VARCHAR(5), file_exists INTEGER)"; and I add some indexation like this: setup = "CREATE INDEX title Files (title, artist, album, genre, comment, extension)"; I insert data into the database and I can query it kinda fast, but when there is lots of files (> 15000) the database seems sluggish and doesn't return the results at all as fast as I would expect (or like!). Is there something I can do with this that can make it faster? Best regards, Jonas
