<div dir="ltr"><div>Today the startup time has returned to normal (less than 15sec) but I don't think I changed anything.  I did a full database clean & shrink using the maintenance tool a few days ago but it didn't have any effect on the startup time then.</div><div><br></div><div>Thanks for your help.<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 8 August 2017 at 22:03, Gilles Caulier-4 [via digiKam] <span dir="ltr"><<a href="/user/SendEmail.jtp?type=node&node=4703593&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>></span> wrote:<br><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">

        Simon is right. Let's the database to be cleaned at least one time.
<br><br>But look also in Step/Misc/Behavior. There is an option to disable
<br>this check at startup.
<br><br>Note that DB clean can be started as a maintenance tool.
<br><br>Gilles Caulier
<br><br></span><div><div class="h5">2017-08-08 13:29 GMT+02:00 Simon Frei <<a href="http:///user/SendEmail.jtp?type=node&node=4703590&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>>:
<div class="m_7633628156777231844shrinkable-quote"><div class='shrinkable-quote'><br>> This is likely due to the new database integrity checks. As far as I
<br>> remember parts of it happen on startup. So first advice is to let it run
<br>> once - it may take a (long) while, but it should be only this one time.
<br>> I Cced Mario who worked on this, so he can give more relevant
<br>> information or correct me if necessary.
<br>>
<br>> On 08/08/17 02:32, meku wrote:
<br>>> In v5.6+ the splash screen pauses at "Reading Database..." for almost 4
<br>>> minutes where previously the entire program would load in under a minute.
<br>>> This is using mysql backend and it does not appear to be waiting for
<br>>> database - nothing is reported in the slow query log.
<br>>>
<br>>> The following backtrace is from v5.7 pre-release appbundle:
<br>>>
<br>>> digikam.database: " ( 1 ) "
<br>>> digikam.database: Search query:
<br>>>  "SELECT DISTINCT Images.id, Images.name, Images.album,
<br>>> Albums.albumRoot,        ImageInformation.rating, Images.category,
<br>>> ImageInformation.format, ImageInformation.creationDate,
<br>>> Images.modificationDate, Images.fileSize,        ImageInformation.width,
<br>>> ImageInformation.height,        ImagePositions.<wbr>latitudeNumber,
<br>>> ImagePositions.longitudeNumber  FROM Images        LEFT JOIN
<br>>> ImageInformation ON Images.id=ImageInformation.<wbr>imageid        LEFT  JOIN
<br>>> ImageMetadata    ON Images.id=ImageMetadata.<wbr>imageid        LEFT  JOIN
<br>>> VideoMetadata    ON Images.id=VideoMetadata.<wbr>imageid        LEFT  JOIN
<br>>> ImagePositions   ON Images.id=ImagePositions.<wbr>imageid        INNER JOIN
<br>>> Albums           ON Albums.id=Images.album WHERE Images.status=1 AND (  ( 1
<br>>> )  );"
<br>>>  ()
<br>>> digikam.database: Search result: 916804
<br>>> digikam.geoiface: "ROADMAP"
<br>>> ^C
<br>>> Thread 1 "digikam" received signal SIGINT, Interrupt.
<br>>> syscall () at ../sysdeps/unix/sysv/linux/<wbr>x86_64/syscall.S:38
<br>>> 38      ../sysdeps/unix/sysv/linux/<wbr>x86_64/syscall.S: No such file or
<br>>> directory.
<br>>> (gdb) bt
<br>>> #0  syscall () at ../sysdeps/unix/sysv/linux/<wbr>x86_64/syscall.S:38
<br>>> #1  0x00007fffec9aa7c5 in QBasicMutex::lockInternal() () from
<br>>> /tmp/.mount_MPSbUb/usr/lib/<wbr>libQt5Core.so.5
<br>>> #2  0x00007fffec9aa856 in QMutex::lock() () from
<br>>> /tmp/.mount_MPSbUb/usr/lib/<wbr>libQt5Core.so.5
<br>>> #3  0x00007fffec0c2332 in Digikam::CoreDbAccess::<wbr>CoreDbAccess
<br>>> (this=<optimised out>)
<br>>>     at
<br>>> /b/dktemp/digikam-master/core/<wbr>libs/database/coredb/<wbr>coredbaccess.cpp:116
<br>>> #4  0x00007ffff7729375 in Digikam::<wbr>AbstractAlbumTreeView::<wbr>doLoadState
<br>>> (this=this@entry=0x13c39b0)
<br>>>     at /b/dktemp/digikam-master/core/<wbr>libs/album/albumtreeview.cpp:<wbr>773
<br>>> #5  0x00007ffff772a4b9 in
<br>>> Digikam::<wbr>AbstractCheckableAlbumTreeView<wbr>::doLoadState (this=0x13c39b0)
<br>>>     at /b/dktemp/digikam-master/core/<wbr>libs/album/albumtreeview.cpp:<wbr>1368
<br>>> #6  0x00007ffff685721a in Digikam::StateSavingObject::<wbr>loadState
<br>>> (this=0x13c39e0)
<br>>>     at
<br>>> /b/dktemp/digikam-master/core/<wbr>libs/widgets/common/<wbr>statesavingobject.cpp:184
<br>>> #7  0x00007ffff798c537 in Digikam::GPSSearchView::<wbr>doLoadState
<br>>> (this=0x13b0940)
<br>>>     at
<br>>> /b/dktemp/digikam-master/core/<wbr>utilities/geolocation/<wbr>mapsearches/gpssearchview.cpp:<wbr>328
<br>>> #8  0x00007ffff685721a in Digikam::StateSavingObject::<wbr>loadState
<br>>> (this=0x13b0970)
<br>>>     at
<br>>> /b/dktemp/digikam-master/core/<wbr>libs/widgets/common/<wbr>statesavingobject.cpp:184
<br>>> #9  0x00007ffff685721a in Digikam::StateSavingObject::<wbr>loadState
<br>>> (this=0x13b05f0)
<br>>>     at
<br>>> /b/dktemp/digikam-master/core/<wbr>libs/widgets/common/<wbr>statesavingobject.cpp:184
<br>>> #10 0x00007ffff75f3047 in Digikam::DigikamView::<wbr>loadViewState
<br>>> (this=this@entry=0xd6b090)
<br>>>     at /b/dktemp/digikam-master/core/<wbr>app/views/digikamview.cpp:724
<br>>> #11 0x00007ffff75f343a in Digikam::DigikamView::<wbr>slotAllAlbumsLoaded
<br>>> (this=0xd6b090)
<br>>>     at /b/dktemp/digikam-master/core/<wbr>app/views/digikamview.cpp:945
<br>>> #12 0x00007ffff7605ab8 in Digikam::DigikamView::qt_<wbr>static_metacall
<br>>> (_o=0xd6b090, _c=<optimised out>, _id=<optimised out>,
<br>>>     _a=<optimised out>) at
<br>>> /b/dktemp/digikam-master/<wbr>build/core/app/moc_<wbr>digikamview.cpp:712
<br>>> #13 0x00007fffecbb9fd8 in QMetaObject::activate(QObject*<wbr>, int, int, void**)
<br>>> () from /tmp/.mount_MPSbUb/usr/lib/<wbr>libQt5Core.so.5
<br>>> #14 0x00007ffff7747146 in Digikam::AlbumManager::<wbr>startScan (
<br>>>     this=0x7ffff7dd6230
<br>>> <_ZZN7Digikam12_GLOBAL__N_<wbr>113Q_QGS_<wbr>creator13innerFunctionEvE6hold<wbr>er>)
<br>>>     at /b/dktemp/digikam-master/core/<wbr>libs/album/albummanager.cpp:<wbr>1090
<br>>> #15 0x00007ffff7554d50 in Digikam::DigikamApp::<wbr>DigikamApp (this=0x78a3a0,
<br>>> __in_chrg=<optimised out>, __vtt_parm=<optimised out>)
<br>>>     at /b/dktemp/digikam-master/core/<wbr>app/main/digikamapp.cpp:276
<br>>> #16 0x00000000004058c8 in main (argc=1, argv=<optimised out>) at
<br>>> /b/dktemp/digikam-master/core/<wbr>app/main/main.cpp:236
<br>>> (gdb)
<br>>>
<br>>>
<br>>>
<br>>> --
<br>>> View this message in context: <a href="http://digikam.1695700.n4.nabble.com/Startup-takes-4-minutes-tp4703585.html" rel="nofollow" link="external" target="_blank">http://digikam.1695700.n4.<wbr>nabble.com/Startup-takes-4-<wbr>minutes-tp4703585.html</a><br>>> Sent from the digikam-users mailing list archive at Nabble.com.
<br>>
</div></div>

        
        
        
        <br>
        <br>
        </div></div><hr noshade size="1" color="#cccccc">
        <div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif"><span class="">
                <div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
                </span><a href="http://digikam.1695700.n4.nabble.com/Startup-takes-4-minutes-tp4703585p4703590.html" target="_blank" rel="nofollow" link="external">http://digikam.1695700.n4.<wbr>nabble.com/Startup-takes-4-<wbr>minutes-tp4703585p4703590.html</a>
        </div><div class="HOEnZb"><div class="h5">
        <div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
                
                To unsubscribe from Startup takes 4 minutes, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
                <a href="http://digikam.1695700.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
        </div></div></div></blockquote></div><br></div>


        
        
        
<br/><hr align="left" width="300" />
View this message in context: <a href="http://digikam.1695700.n4.nabble.com/Startup-takes-4-minutes-tp4703585p4703593.html">Re: Startup takes 4 minutes</a><br/>
Sent from the <a href="http://digikam.1695700.n4.nabble.com/digikam-users-f1735189.html">digikam-users mailing list archive</a> at Nabble.com.<br/>