I thought it was fixed but in some case the lighttable is still way too slow. I took some time to look at this and I found the culprit.
Note that the slowness is mostly when the collection is set to tag, rights, publisher, creator or description. It is also a bit more slower on the zoomable view than on the file-manager one. In this case the SQL query is indeed taking some good chunk on time and on the lighttable the zoomable view the loop in lighttable.c:945 (expose_zoomable) makes dt crawl :( I have 36000 images into dt and even using a tag value which selects 350 of them trigger the slowness. It take something like 1 or 2 seconds to have the on-over image selected. Not really usable. This is because the query (lib->statements.main_query) is run again and again and each one takes something like 0.02". As I said using a collection filter based on filename does not exhibit this speed issue as the SQL statement is fast (not mesurable in fact). After thinking about this, it seems to me that we probably want to create a new temporary table into the database to keep the imgid for the current collection (same idea than the selected_images table). Then it will be possible to display the images very fast on the lighttable as the query will be basically be: SELECT * FROM collected_images; I'm looking for thoughts about this possible enhancement. And of course I'm volunteering to implement this if it looks ok. -- 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 ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk _______________________________________________ darktable-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/darktable-devel
