<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

this check at startup.

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

> 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

> 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

>> 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

>> 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

>> 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>>> --

>> 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.nabble.com/Startup-takes-4-minutes-tp4703585.html</a> >> 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/>