2013-12-18, 10:37
But it is the where-condition that makes it useful with many pictures in the database. I tried first with
SELECT strPath,strFilename FROM Files ORDER BY RANDOM() LIMIT 250
but it takes forever on a raspeberry pi and a few thousand pictures in the database. I think since it selects all rows in the db and then sort them, which is too much for a very limited HW.
Im not sure if 'ORDER BY RANDOM()' gives anything though. Im thinking it might be a bit faster than to use randomizing in ruuks plugin after "delivery", and will make me not always see pictures in the same order they were inserted into the database.
SELECT strPath,strFilename FROM Files ORDER BY RANDOM() LIMIT 250
but it takes forever on a raspeberry pi and a few thousand pictures in the database. I think since it selects all rows in the db and then sort them, which is too much for a very limited HW.
Im not sure if 'ORDER BY RANDOM()' gives anything though. Im thinking it might be a bit faster than to use randomizing in ruuks plugin after "delivery", and will make me not always see pictures in the same order they were inserted into the database.
