Hi Johannes,
It doesn't seem to make a difference. both when running off the copy in
/dev/shm, or after copying it back and running it again.
I'm a little confused though --- is darktable continually running sql
queries? I see this sluggishness even just moving my mouse around in the
'file manager', or scrolling in the file manager. I kinda assumed that
once I selected the tags under 'collect images', the SQL search was done
once, and the rest of the work was done on the results... Changing the
selected tags seems pretty quick - it's just the interaction afterwards
that is slow...
I do have quite a few tags - it looks like Aperture exported every face I
had tagged in aperture as a separate tag, so I probably have a few hundred
or so.
Other ideas / suggestions?
Best regards,
Warren
On Mon, Feb 18, 2013 at 9:08 PM, johannes hanika <[email protected]> wrote:
> you're potentially running into an issue with the sqlite3 backend.
>
> if your distro allows it, try copying ~/.config/darktable/library.db
> to /dev/shm and start
>
> darktable --library /dev/shm/library.db
>
> and copy it back after that. traditionally, in-ram access made sql run
> a lot faster, if that doesn't solve your issue we might need another
> index on the tags table (do you also have a lot of tags?).
>
> j.
>
> On Tue, Feb 19, 2013 at 2:36 PM, Warren Baird
> <[email protected]> wrote:
> > Hi all,
> >
> > I've started trying to use darktable 'for real' and have run into a
> fairly
> > annoying issue. The lighttable UI becomes really sluggish if I create a
> > collection defined by taking a tag with a lot of matches, and then
> selecting
> > "Exclude Images" and selecting a tag that matches a small number of
> images.
> >
> > I've tried this with a collection of about 7500 images, and an 'exclude'
> tag
> > that matches about 300 of them - and another collection of about 1100
> > images, and an exclude tag of maybe 200 or so images.
> >
> > In both cases the general UI response gets very slow - the highlight lags
> > about a second behind mouse movements, and scrolling gets very slow.
> >
> > if I select 'clear this rule' on the exluded tag, the performance gets a
> > *lot* better.
> >
> > I often want to scan through a relatively large # of images looking for
> > things that might work for a particular art project - but I usually want
> to
> > exclude any images that I've used in previous projects...
> >
> > Any suggestions on alternative ways to accomplish this, or how to speed
> this
> > up would be great!
> >
> > Should I log a bug?
> >
> > best regards,
> >
> > Warren
> >
> >
> > --
> > Warren Baird - Photographer and Digital Artist
> > http://www.synergisticimages.ca
> >
> >
> ------------------------------------------------------------------------------
> > The Go Parallel Website, sponsored by Intel - in partnership with
> Geeknet,
> > is your hub for all things parallel software development, from weekly
> > thought
> > leadership blogs to news, videos, case studies, tutorials, tech docs,
> > whitepapers, evaluation guides, and opinion stories. Check out the most
> > recent posts - join the conversation now.
> http://goparallel.sourceforge.net/
> > _______________________________________________
> > Darktable-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/darktable-users
> >
>
--
Warren Baird - Photographer and Digital Artist
http://www.synergisticimages.ca
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Darktable-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/darktable-users
