[Digikam-users] Re: Digikam startup takes ~ 30 hours

[Benjamin Harders]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> Maybe i have to wait until the NAS finished indexing. Or I will drop the
> table and let digikam re-index all folders again.
> 
> By the way: Since I am using mysql for digikam, every time I create a
> new tag I have to wait five to ten minutes until digikam works again.
> Writing an existing tag of my database to one picture, takes one second.

Maybe someone got the some probs. I deleted the database and let digikam
re-index all photos. After about one hundred thousand files (within a
few hours in total) it slowed down extremly to a few pics per minute. In
the sql-process list i found this entry with a run-time of about one minute:
REPLACE INTO TagsTree SELECT node.id, parent.pid FROM Tags AS node, Tags
AS ...
Something is wrong with this sql statement.
https://bugs.kde.org/show_bug.cgi?id=258409#c12
Is the whole TagsTree build new for every new photo?
This may explain my problem with the creation of new tags.

Now I removed the last ten thousand pics including meta tags from the
dir and let digikam finish the index on the other three hundred thousand
files without included meta tags. This took only about two hours. After
that digikam did not show up. I still can see the splash screen "reading
database". Obviously digikam shows some very slow (~300 KiB/s) activity
towards the NAS. Both systems do not fully use their processors (~20% -
30%). In the database In the database I have three sleeping connections
of digikam (13596 - 20671 sec); no other activity. Do you have an
explanation for this strange behavior, producing little network traffic
between my PC and the NAS? What is digikam supposed to do after indexing
new files? Nfsd on the NAS indicates some file system operations. But
for what?

I am praying, that this start-up will not take three days to succeed...

Ben
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJNy9jaAAoJEJiq7tQPRElPlDEIAIwxNYX1T3qDWR84BTOYLghh
Exf2u1Y1xwJ9ilHjWfed/VQ5g3KFHoDi6qDFjNXV3BZdgttNKr4hIKx78ezJkn7y
E4Zfhl5kHa/kuOUsHYeG/QWTTU50n7aH70FQHZ8ZmHXJ6zrkaXzQQTZ4uNfZE5bQ
rxXcVLSxJ2dRQHqT2KAhQmVFlKmnqHU3EGyY8fiG02R7LfFUgYcGy6PFBMpYf2WN
BBMcf5/xhaCOag6vYVLn9hk80ULsBkLp5Sz8+M1vJWlrvRoGCZF/PnrcP6g1NoD8
aORkmeDDiTdT4UYqIdonhWm4It3ekWhr414avGKgMdmAejEsVWvxSASweXcfDXA=
=znrP
-----END PGP SIGNATURE-----