Re: [darktable-dev] db upgrade can be slow
* Pascal Obry [01-16-21 13:12]: > > For people using the "master" version. > > Beware that the next database upgrade can take quite some time. > > This new version is modifying quite a lot the structure by adding many > foreign keys and cascade support. This will avoid dangling data in the > db and will enforce a better consistency. > > There is some reports that the conversion is taking 1 minute for around > 50k images. This depends also of the disk speed. > > Anyway, when upgrading be patient and take a coffee :) >190k images beginning size of library.db936312832 time darktable -d all 0.66 application_directory: /usr/bin 0.000102 darktable.datadir: /usr/share/darktable 0.000117 darktable.plugindir: /usr/lib64/darktable 0.000128 darktable.localedir: /usr/share/locale 0.000164 darktable.configdir: /home/paka/.config/darktable 0.000183 darktable.cachedir: /home/paka/.cache/darktable 0.000194 darktable.sharedir: /usr/share 0.000206 darktable.tmpdir: /tmp [memory] at startup [memory] max address space (vmpeak): 94340 kB [memory] cur address space (vmsize): 94308 kB [memory] max used memory (vmhwm ): 30700 kB [memory] cur used memory (vmrss ): 30700 kB 0.000261 new_xdg_data_dirs: (null) WINDOW DECORATIONS RELOADED WINDOW DECORATIONS RELOADED 0.424459 output profile `2-Color separation look (Red x Black)' color space `Lab ' not supported for histogram profile 0.424472 output profile `2-Color separation look (Red x Green)' color space `Lab ' not supported for histogram profile 0.424475 output profile `Invert lightness' color space `Lab ' not supported for histogram profile 0.424477 output profile `Old picture' color space `Lab ' not supported for histogram profile 0.444572 [init sql] library: /home/paka/.config/darktable/library.db, data: /home/paka/.config/darktable/data.db [init] can't copy back from images_old [init] FOREIGN KEY constraint failed [init] database `library.db' couldn't be upgraded from version 30 to 33. aborting ERROR : cannot open database real15m57.042s user8m41.566s sys 7m6.821s not working for me :( -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.orgopenSUSE Community Memberfacebook/ptilopteri Photos: http://wahoo.no-ip.org/piwigo paka @ IRCnet freenode ___ darktable developer mailing list to unsubscribe send a mail to darktable-dev+unsubscr...@lists.darktable.org
Re: [darktable-dev] db upgrade can be slow
Le samedi 16 janvier 2021 à 19:19 +0100, Hubert Kowalski a écrit : > Great point for release notes then ;) Indeed, and done :) -- 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 developer mailing list to unsubscribe send a mail to darktable-dev+unsubscr...@lists.darktable.org
Re: [darktable-dev] db upgrade can be slow
Great point for release notes then ;) sob., 16 sty 2021 o 19:10 Pascal Obry napisał(a): > > For people using the "master" version. > > Beware that the next database upgrade can take quite some time. > > This new version is modifying quite a lot the structure by adding many > foreign keys and cascade support. This will avoid dangling data in the > db and will enforce a better consistency. > > There is some reports that the conversion is taking 1 minute for around > 50k images. This depends also of the disk speed. > > Anyway, when upgrading be patient and take a coffee :) > > Regards, > > -- > 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 developer mailing list > to unsubscribe send a mail to > darktable-dev+unsubscr...@lists.darktable.org > > -- Pozdrawiam, Hubert Kowalski ___ darktable developer mailing list to unsubscribe send a mail to darktable-dev+unsubscr...@lists.darktable.org
[darktable-dev] db upgrade can be slow
For people using the "master" version. Beware that the next database upgrade can take quite some time. This new version is modifying quite a lot the structure by adding many foreign keys and cascade support. This will avoid dangling data in the db and will enforce a better consistency. There is some reports that the conversion is taking 1 minute for around 50k images. This depends also of the disk speed. Anyway, when upgrading be patient and take a coffee :) Regards, -- 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 developer mailing list to unsubscribe send a mail to darktable-dev+unsubscr...@lists.darktable.org