Hi AlicVB, > 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 :(
Will do testing on my side then. > But be carrefull, I'm a noob in sql, so I don't now if adding index can > have weird effect elsewhere or not ! No, it can't. If I identify the SQL statement needed I'll propose a patch, we really want to handle this properly in dt. Thanks, 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
