Ok - I've opened a bug for it - http://www.darktable.org/redmine/issues/9275
the video showing the behaviour is at
http://www.darktable.org/redmine/attachments/download/471/slow_ui_sample.m4v
On Mon, Feb 18, 2013 at 9:34 PM, Warren Baird
<[email protected]>wrote:
> One addition bit of information that I noticed - If I do an 'And' or 'Or'
> operation, the performance is ok. If I do an 'Except' operation, then the
> performance is bad. Pretty weird - I recorded a short video showing the
> issue - I'll open a bug and attach it..
>
>
>
> On Mon, Feb 18, 2013 at 9:18 PM, Warren Baird <[email protected]
> > wrote:
>
>> 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
>>
>
>
>
> --
> Warren Baird - Photographer and Digital Artist
> http://www.synergisticimages.ca
>
--
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
