[Xycl]

MyPicsDB 12.2.6

available in my repository.

New menus

• N random pictures
  
• Saved filter wizard settings
  

especially for use with ruuk's plugin slideshow screensaver.
Thanks to nemj.

---

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.

I didn't see your response before releasing the new MyPicsDB

Raspberry Pi?
Makes sense to limit the possible result set with the where condition.
I tried it with 11k pictures an a Core i7, Sqlite and MySql. There was no performance gain with this where condition.

Okay then there will be a new version with this limiting condition.