Le 15/09/2013 10:46, AlicVB a écrit : > Hi Pascal, > > I had the same pb on my "production" copy of dt (~50K photos) I've > solved this with manually adding some index to the db. I've added index > on tagged_images(tagid) tags(id) film_rolls(folder) images(film_id) > I don't think all this index are needed, but I was too lazy to test them > one by one :(
Thanks a lot!!!! You saved me lot of time :) The most impressive speed-up was with: CREATE INDEX images_film_id_index ON images(film_id); But others indexes are making lot of sense to me, it cannot hurt and we certainly gain a bit of speed with: CREATE INDEX film_rolls_folder_index ON film_rolls(folder); I'll create the 4 indexes, stay tuned! Pascal. -- Pascal Obry / Magny Les Hameaux (78) The best way to travel is by means of imagination http://v2p.fr.eu.org http://www.obry.net gpg --keyserver keys.gnupg.net --recv-key F949BD3B ------------------------------------------------------------------------------ LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk _______________________________________________ darktable-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/darktable-devel
