<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hey Simon,<br>
Hey meku, <br>
<br>
Integrity checks are only done before and after vacuuming which is
never done at startup. This is only done in maintenance. <br>
Nevertheless, database cleaning is done if configured in
setup->misc. This can take some time at first startup as the
stale image ids from the core database are removed. After the first
start, no significant latency should occur. <br>
<br>
Looking at the trace, I think there was a similar problem in
bugzilla some time ago. Search for slow startup. I think there was a
solution. You should find it. The trace implies a slow process in
loading album tree views. There are multiple of them. One in the
main view, one in the searches sidebar (the album selection
combobox), and multiple in the fuzzy sidebar.<br>
In the digikamrc the selected albums are stored the name of the
configuration keys is always something containing
AlbumSelectCombobox. Remove the values of these configuration.<br>
In the load state phase, the last selected albums are selected.
There, a time latency can occur.<br>
<br>
How many albums and images do you have?<br>
<br>
Hope this helps.<br>
<br>
Cheers<br>
Mario <br>
<br>
<div class="gmail_quote">Am 8. August 2017 13:29:55 MESZ schrieb
Simon Frei <a class="moz-txt-link-rfc2396E" href="mailto:freisim93@gmail.com"><freisim93@gmail.com></a>:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex;
border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">This is likely due to the new database integrity checks. As far as I
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.
I Cced Mario who worked on this, so he can give more relevant
information or correct me if necessary.
On 08/08/17 02:32, meku wrote:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> 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.
This is using mysql backend and it does not appear to be waiting for
database - nothing is reported in the slow query log.
The following backtrace is from v5.7 pre-release appbundle:
digikam.database: " ( 1 ) "
digikam.database: Search query:
"SELECT DISTINCT <a href="http://Images.id">Images.id</a>, <a href="http://Images.name">Images.name</a>, Images.album,
Albums.albumRoot, ImageInformation.rating, Images.category,
ImageInformation.format, ImageInformation.creationDate,
Images.modificationDate, Images.fileSize, ImageInformation.width,
ImageInformation.height, ImagePositions.latitudeNumber,
ImagePositions.longitudeNumber FROM Images LEFT JOIN
ImageInformation ON <a href="http://Images.id">Images.id</a>=ImageInformation.imageid LEFT JOIN
ImageMetadata ON <a href="http://Images.id">Images.id</a>=ImageMetadata.imageid LEFT JOIN
VideoMetadata ON <a href="http://Images.id">Images.id</a>=VideoMetadata.imageid LEFT JOIN
ImagePositions ON <a href="http://Images.id">Images.id</a>=ImagePositions.imageid INNER JOIN
Albums ON <a href="http://Albums.id">Albums.id</a>=Images.album WHERE Images.status=1 AND ( ( 1
) );"
()
digikam.database: Search result: 916804
digikam.geoiface: "ROADMAP"
^C
Thread 1 "digikam" received signal SIGINT, Interrupt.
syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
38 ../sysdeps/unix/sysv/linux/x86_64/syscall.S: No such file or
directory.
(gdb) bt
#0 syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38
#1 0x00007fffec9aa7c5 in QBasicMutex::lockInternal() () from
/tmp/.mount_MPSbUb/usr/lib/<a href="http://libQt5Core.so">libQt5Core.so</a>.5
#2 0x00007fffec9aa856 in QMutex::lock() () from
/tmp/.mount_MPSbUb/usr/lib/<a href="http://libQt5Core.so">libQt5Core.so</a>.5
#3 0x00007fffec0c2332 in Digikam::CoreDbAccess::CoreDbAccess
(this=<optimised out>)
at
/b/dktemp/digikam-master/core/libs/database/coredb/coredbaccess.cpp:116
#4 0x00007ffff7729375 in Digikam::AbstractAlbumTreeView::doLoadState
(this=this@entry=0x13c39b0)
at /b/dktemp/digikam-master/core/libs/album/albumtreeview.cpp:773
#5 0x00007ffff772a4b9 in
Digikam::AbstractCheckableAlbumTreeView::doLoadState (this=0x13c39b0)
at /b/dktemp/digikam-master/core/libs/album/albumtreeview.cpp:1368
#6 0x00007ffff685721a in Digikam::StateSavingObject::loadState
(this=0x13c39e0)
at
/b/dktemp/digikam-master/core/libs/widgets/common/statesavingobject.cpp:184
#7 0x00007ffff798c537 in Digikam::GPSSearchView::doLoadState
(this=0x13b0940)
at
/b/dktemp/digikam-master/core/utilities/geolocation/mapsearches/gpssearchview.cpp:328
#8 0x00007ffff685721a in Digikam::StateSavingObject::loadState
(this=0x13b0970)
at
/b/dktemp/digikam-master/core/libs/widgets/common/statesavingobject.cpp:184
#9 0x00007ffff685721a in Digikam::StateSavingObject::loadState
(this=0x13b05f0)
at
/b/dktemp/digikam-master/core/libs/widgets/common/statesavingobject.cpp:184
#10 0x00007ffff75f3047 in Digikam::DigikamView::loadViewState
(this=this@entry=0xd6b090)
at /b/dktemp/digikam-master/core/app/views/digikamview.cpp:724
#11 0x00007ffff75f343a in Digikam::DigikamView::slotAllAlbumsLoaded
(this=0xd6b090)
at /b/dktemp/digikam-master/core/app/views/digikamview.cpp:945
#12 0x00007ffff7605ab8 in Digikam::DigikamView::qt_static_metacall
(_o=0xd6b090, _c=<optimised out>, _id=<optimised out>,
_a=<optimised out>) at
/b/dktemp/digikam-master/build/core/app/moc_digikamview.cpp:712
#13 0x00007fffecbb9fd8 in QMetaObject::activate(QObject*, int, int, void**)
() from /tmp/.mount_MPSbUb/usr/lib/<a href="http://libQt5Core.so">libQt5Core.so</a>.5
#14 0x00007ffff7747146 in Digikam::AlbumManager::startScan (
this=0x7ffff7dd6230
<_ZZN7Digikam12_GLOBAL__N_113Q_QGS_creator13innerFunctionEvE6holder>)
at /b/dktemp/digikam-master/core/libs/album/albummanager.cpp:1090
#15 0x00007ffff7554d50 in Digikam::DigikamApp::DigikamApp (this=0x78a3a0,
__in_chrg=<optimised out>, __vtt_parm=<optimised out>)
at /b/dktemp/digikam-master/core/app/main/digikamapp.cpp:276
#16 0x00000000004058c8 in main (argc=1, argv=<optimised out>) at
/b/dktemp/digikam-master/core/app/main/main.cpp:236
(gdb)
--
View this message in context: <a href="http://digikam.1695700.n4.nabble.com/Startup-takes-4-minutes-tp4703585.html">http://digikam.1695700.n4.nabble.com/Startup-takes-4-minutes-tp4703585.html</a>
Sent from the digikam-users mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.
</blockquote>
</pre>
</blockquote>
</div>
<br>
-- <br>
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail
gesendet.
</body>
</html>