Thanks! That seems to have helped considerably. (The tagged_images_imgid_index already existed, by the way).
It is still oddly slow applying star ratings (a few seconds for 2-12 selected images, seemingly not dependent on how many, but just one selected is faster). Also, typing tags into the tagging text box is quite slow, I guess because it's doing a lot of string compares to show the matching tag list (about 1550 tags in my database). Is there a way to turn that off? Anyway, I think I can work with this without having to break up my database. Thanks, Ed On Sun, Mar 10, 2019 at 4:31 AM Pascal Obry <[email protected]> wrote: > > Ok, I may have an idea. > > Can you do that: > > - backup your library.db > - run > > $ sqlite3 library.db > > And enter the following command at the "sqlite >" prompt. > > CREATE INDEX tagged_images_index ON tagged_images (imgid, tagid); > > And test again. If still slow you may try: > > CREATE INDEX tagged_images_imgid_index ON tagged_images (imgid); > > Thanks. > > -- > Pascal Obry / Magny Les Hameaux (78) > > The best way to travel is by means of imagination > > http://www.obry.net > > gpg --keyserver keys.gnupg.net --recv-key F949BD3B > > ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to [email protected]
