Re: [darktable-user] Re: darktable 2.0.x library

[August Schwerdfeger]

I have found that Darktable's performance depends far less on the overall
number of *images* in the database than on the lexical properties of the
*tags* in the database. I have one database with well over 50,000 images,
with which I notice no performance problems, and another database with
about 3,000 images, with which any operation involving tags is so slow as
to render Darktable nearly unusable.

The difference, so far as I have been able to determine, is that the images
in the smaller database each have a tag to identify the subject, resulting
in an image/tag relation with a different structure to the usual.

--
August Schwerdfeger
aug...@schwerdfeger.name

On Wed, Sep 21, 2016 at 1:46 PM, Frank J.  wrote:

> Am 21.09.2016 um 20:00 schrieb Pascal Obry:
> ..
> > Strange since some of us have far more than 50k images. It was even
> > reported by a user that he had 100k images IIRC.
> >
> > Maybe he reached an issue with the "old" mipmap cache?
> >
> > Not sure, but to me dt is fast for everything.
> >
>
> I have nearly 50K on my system.
> I've no problems with watchching or developing my photos.
>
> Export or creating thumbs is a bit slow because it's only an i3 with
> graphics on board, no GPU. A'm working to change this soon ..
>
> Slowest part, I think, is the tagging.
> Maybe I'm tagging too much: place, persons, event, ...
>
> For my old slide-scans I tag also film-type and camera-model, cause they
> have no exif-data.
>
> DT try to give my some intelligent suggestions while tagging.
> For example: when I tag (the german word for) "house-cleaning", DT
> suggests to tag also the name of my wife  ;-)
>   - really!
>
> DT trys to analyse "pairs of tagging". The database-table "tagxtag" has
> 2.2 Million entries for my 45K pictures.
> Typing in the tag-mask seems to freeze the programm. I have to wait many
> seconds.
> I would like to switch this feature off for faster work.
>
> --
> Frank
>
>
> 
> 
> darktable user mailing list
> to unsubscribe send a mail to darktable-user+unsubscribe@
> lists.darktable.org
>
>


darktable user mailing list
to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org

Re: [darktable-user] Re: darktable 2.0.x library

[Frank J.]

Am 21.09.2016 um 20:00 schrieb Pascal Obry:
..
> Strange since some of us have far more than 50k images. It was even
> reported by a user that he had 100k images IIRC.
> 
> Maybe he reached an issue with the "old" mipmap cache?
> 
> Not sure, but to me dt is fast for everything.
> 

I have nearly 50K on my system.
I've no problems with watchching or developing my photos.

Export or creating thumbs is a bit slow because it's only an i3 with
graphics on board, no GPU. A'm working to change this soon ..

Slowest part, I think, is the tagging.
Maybe I'm tagging too much: place, persons, event, ...

For my old slide-scans I tag also film-type and camera-model, cause they
have no exif-data.

DT try to give my some intelligent suggestions while tagging.
For example: when I tag (the german word for) "house-cleaning", DT
suggests to tag also the name of my wife  ;-)
  - really!

DT trys to analyse "pairs of tagging". The database-table "tagxtag" has
2.2 Million entries for my 45K pictures.
Typing in the tag-mask seems to freeze the programm. I have to wait many
seconds.
I would like to switch this feature off for faster work.

--
Frank



darktable user mailing list
to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org

Re: [darktable-user] Re: darktable 2.0.x library

[Pascal Obry]

Le mercredi 21 septembre 2016 à 17:54 +, Helge Hielscher a écrit :
> Bob Keefer wrote at dpreview that he had to switch to digikam for
> his 
> 50,000 images:
>   https://www.dpreview.com/forums/thread/4047509

Strange since some of us have far more than 50k images. It was even
reported by a user that he had 100k images IIRC.

Maybe he reached an issue with the "old" mipmap cache?

Not sure, but to me dt is fast for everything.

-- 
  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 user mailing list
to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org

[darktable-user] Re: darktable 2.0.x library

[Helge Hielscher]

Hello Sascha,

my first post through gmane did not get through, so here is my second 
attempt.

On Wed, 21 Sep 2016 15:31:01 +0200, Sascha Oleszczuk wrote:

> 1.) do you perform a backup?
> 2.) is there a critical amount of images it can manage? or do you import
> all your images and never perform a cleanup?

Bob Keefer wrote at dpreview that he had to switch to digikam for his 
50,000 images:
  https://www.dpreview.com/forums/thread/4047509

HTH,
Helge


darktable user mailing list
to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org

Re: [darktable-user] darktable 2.0.x library

[Patrick Shanahan]

* Sascha Oleszczuk  [09-21-16 09:33]:
> Hi All,
> 
> are there any recommendation regarding the sqlite db (library).
> 
> 1.) do you perform a backup?

daily

> 2.) is there a critical amount of images it can manage? 

I have +80k

> or do you import all your images 

yes

>and never perform a cleanup?

I occasionally run:
  sqlite3  ./library.db "VACUUM;"
  and
  sqlite3  ./library.db "PRAGMA integrity_check"
but on a lib copy, just-in-case
  
-- 
(paka)Patrick Shanahan   Plainfield, Indiana, USA  @ptilopteri
http://en.opensuse.orgopenSUSE Community Memberfacebook/ptilopteri
http://wahoo.no-ip.orgPhoto Album: http://wahoo.no-ip.org/gallery2
Registered Linux User #207535@ http://linuxcounter.net

darktable user mailing list
to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org

[darktable-user] darktable 2.0.x library

[Sascha Oleszczuk]

Hi All,

are there any recommendation regarding the sqlite db (library).

1.) do you perform a backup?
2.) is there a critical amount of images it can manage? or do you import
all your images and never perform a cleanup?

Thx
Sascha


darktable user mailing list
to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org

Re: [darktable-user] Re: display bug on mac (DT 2.0.6 and 2.0.5)

[Tobias Ellinghaus]

Am Mittwoch, 21. September 2016, 14:32:11 CEST schrieb laurent wawrzyniak:
> Thanks Tobias and Daniel for your answers.
> 
> Thanks for the ctrl+H tip, it works correctly even if sometimes,it freezes
> for no reason.
> 
> For the darktable.css, I wasn't able to find it.What is the complete path
> on mac please?

Maybe it's in side the DMG? Can you use your system's file search feature? I 
can't check this myself as I don't have a Mac.

> Thanks in advance,
> Laurent

Tobias

> 2016-09-20 8:34 GMT+02:00 laurent wawrzyniak :
> > Hello,
> > 
> > As you can see here https://share.orange.fr/#DHUNox2har2ec78820ab
> > 
> > in 2.0.6 (same in 2.0.5), the minimum size on the DT window is bigger than
> > 1440 pixels wide of my macbookair.
> > 
> > The right part of the window is not visible and the letter size of menu is
> > bigger than in 2.0.4
> > 
> > I love DT because, it needs few ressources and work well on a relatively
> > old notebook (which is not the case of heavyroom...)
> > 
> > But with this bug, impossible to work on the go with a small display.
> > 
> > Thanks in advance.
> > 
> > Laurent
> 
> 
> darktable user mailing list
> to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.org



signature.asc
Description: This is a digitally signed message part.