One suggested future feature and one bug report

1

Hi,
First of all pardon my french, second of all thanks a lot regarding all the work done here on this software! You’re really working in a direction that seems the best one to me.

One suggested future feature: If I may, I would like to suggest you to give users the possibility to automatically sort out photos gathered in one item by their names. When gathering photos this way, you sometime loose the alaphabetic order that was “on” in the general view.

**One bug report :**I have exactly the same problem as the person here, I can see photos in their thumbnails but not in the item views. Either they are really slow to appear on the screen, or they don’t appear at all. I was careful not to move my photos from their original location. Maybe it’s linked with the high number of photos I am managing : 1250 altogether. TROPY was first really slow as I imported all the photos. By ranging them in bigger items (I am using most of the time 40 pages long documents), it went however better.

Plus, I feel obliged to tell you that I had several error messages while using TROPY, like “SLQ Resource Request TImed Out” or “data_busy failed to import” that might be linked in someway with that.

If you have time to help me, I upload in this topic the project log exactly as recomended to the person on the first answer here.
Thanks a lot anyway for what’s been done already,
All the Best,

{“level”:“info”,“message”:“logger initialized at level verbose”,“label”:“project”,“timestamp”:“2018-05-31T14:43:33.073Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Tchsbrrra\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.448Z”}
{“level”:“verbose”,“message”:“restoring settings@tropy…”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.448Z”}
{“level”:“verbose”,“message”:“restoring ui@tropy…”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.479Z”}
{“level”:“verbose”,“message”:“settings.restore \u001b[90m#1\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.479Z”}
{“level”:“verbose”,“message”:“ui.restore \u001b[90m#2\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.479Z”}
{“level”:“verbose”,“message”:“settings.update \u001b[90m#3\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.563Z”}
{“level”:“verbose”,“message”:“plugins scanned: 0”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.650Z”}
{“level”:“verbose”,“message”:“plugins loaded: 0”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.651Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Tchsbrrra\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.665Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Tchsbrrra\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.666Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Tchsbrrra\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.667Z”}
{“level”:“verbose”,“message”:“intl.update \u001b[90m#4\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.781Z”}
{“level”:“verbose”,“message”:“keymap.update \u001b[90m#5\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.790Z”}
{“level”:“verbose”,“message”:“project.open \u001b[90m#6\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.790Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Tchsbrrra\Documents\BIT.tpy”,“label”:“project”,“timestamp”:“2018-05-31T14:43:38.793Z”}
{“level”:“verbose”,“message”:“project ready after 7690.195ms (1861.915ms)”,“label”:“project”,“timestamp”:“2018-05-31T14:43:40.422Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Tchsbrrra\Documents\BIT.tpy”,“label”:“project”,“timestamp”:“2018-05-31T14:43:40.570Z”}
{“level”:“verbose”,“message”:“ontology.load \u001b[90m#7\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:40.579Z”}
{“level”:“warn”,“message”:“SLOW: ontology.load”,“label”:“project”,“timestamp”:“2018-05-31T14:43:40.724Z”}
{“level”:“verbose”,“message”:“project.opened \u001b[90m#8\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:40.913Z”}
{“level”:“verbose”,“message”:“restoring nav@9384fbe5-f0f8-4097-a9f2-5f342b9b8ee7…”,“label”:“project”,“timestamp”:“2018-05-31T14:43:40.938Z”}
{“level”:“verbose”,“message”:“restoring imports@9384fbe5-f0f8-4097-a9f2-5f342b9b8ee7…”,“label”:“project”,“timestamp”:“2018-05-31T14:43:40.939Z”}
{“level”:“verbose”,“message”:“nav.restore \u001b[90m#9\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:40.940Z”}
{“level”:“verbose”,“message”:“imports.restore \u001b[90m#10\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.006Z”}
{“level”:“verbose”,“message”:“history.drop \u001b[90m#11\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.019Z”}
{“level”:“verbose”,“message”:“list.load \u001b[90m#12\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.022Z”}
{“level”:“verbose”,“message”:“tag.load \u001b[90m#13\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.033Z”}
{“level”:“verbose”,“message”:“item.load \u001b[90m#14\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.073Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Tchsbrrra\Documents\BIT.tpy”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.137Z”}
{“level”:“verbose”,“message”:“photo.load \u001b[90m#15\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.138Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Tchsbrrra\Documents\BIT.tpy”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.155Z”}
{“level”:“verbose”,“message”:“metadata.load \u001b[90m#16\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.157Z”}
{“level”:“verbose”,“message”:“selection.load \u001b[90m#17\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.172Z”}
{“level”:“verbose”,“message”:“note.load \u001b[90m#18\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.180Z”}
{“level”:“verbose”,“message”:“list.load \u001b[90m#19(12) Δ201ms\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.223Z”}
{“level”:“verbose”,“message”:“tag.load \u001b[90m#20(13) Δ238ms\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:41.273Z”}
{“level”:“verbose”,“message”:“item.load \u001b[90m#21(14) Δ2s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:43.199Z”}
{“level”:“warn”,“message”:“SLOW: item.load”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.047Z”}
{“level”:“verbose”,“message”:“photo.load \u001b[90m#22(15) Δ5s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.134Z”}
{“level”:“warn”,“message”:“SLOW: photo.load”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.450Z”}
{“level”:“verbose”,“message”:“selection.load \u001b[90m#23(17) Δ5s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.452Z”}
{“level”:“warn”,“message”:“SLOW: selection.load”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.467Z”}
{“level”:“verbose”,“message”:“metadata.load \u001b[90m#24(16) Δ5s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.489Z”}
{“level”:“warn”,“message”:“SLOW: metadata.load”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.539Z”}
{“level”:“verbose”,“message”:“note.load \u001b[90m#25(18) Δ5s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.589Z”}
{“level”:“warn”,“message”:“SLOW: note.load”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.599Z”}
{“level”:“verbose”,“message”:"*search query took 6s",“label”:“project”,“timestamp”:“2018-05-31T14:43:46.704Z”}
{“level”:“verbose”,“message”:“qr.update \u001b[90m#26\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:43:46.705Z”}
{“level”:“verbose”,“message”:“photo.update \u001b[90m#30\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:45:06.353Z”}
{“level”:“verbose”,“message”:“photo.consolidate \u001b[90m#31\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:45:07.435Z”}
{“level”:“verbose”,“message”:“photo.update \u001b[90m#33\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:45:15.144Z”}
{“level”:“verbose”,“message”:“activity.update \u001b[90m#34(31) Δ8s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:45:15.193Z”}
{“level”:“verbose”,“message”:“photo.consolidate \u001b[90m#35(31) Δ8s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:45:15.665Z”}
{“level”:“warn”,“message”:“SLOW: photo.consolidate”,“label”:“project”,“timestamp”:“2018-05-31T14:45:15.670Z”}
{“level”:“verbose”,“message”:“item.open \u001b[90m#36\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:46:16.160Z”}
{“level”:“verbose”,“message”:“photo.update \u001b[90m#43\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:46:34.749Z”}
{“level”:“verbose”,“message”:“photo.consolidate \u001b[90m#44\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:46:35.827Z”}
{“level”:“verbose”,“message”:“photo.update \u001b[90m#48\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:46:55.324Z”}
{“level”:“verbose”,“message”:“activity.update \u001b[90m#49(44) Δ20s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:46:55.381Z”}
{“level”:“verbose”,“message”:“photo.consolidate \u001b[90m#50(44) Δ20s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:46:55.386Z”}
{“level”:“warn”,“message”:“SLOW: photo.consolidate”,“label”:“project”,“timestamp”:“2018-05-31T14:46:55.389Z”}
{“level”:“verbose”,“message”:“nav.update \u001b[90m#62\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:47:41.226Z”}
{“level”:“verbose”,“message”:“photo.update \u001b[90m#63\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:47:46.807Z”}
{“level”:“verbose”,“message”:“item.open \u001b[90m#65\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:47:47.694Z”}
{“level”:“verbose”,“message”:“photo.consolidate \u001b[90m#66\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:47:47.855Z”}
{“level”:“verbose”,“message”:“photo.update \u001b[90m#71\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:48:19.183Z”}
{“level”:“verbose”,“message”:“photo.update \u001b[90m#72\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:48:19.872Z”}
{“level”:“verbose”,“message”:“activity.update \u001b[90m#73(66) Δ32s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:48:19.925Z”}
{“level”:“verbose”,“message”:“photo.consolidate \u001b[90m#74(66) Δ32s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:48:19.943Z”}
{“level”:“warn”,“message”:“SLOW: photo.consolidate”,“label”:“project”,“timestamp”:“2018-05-31T14:48:19.953Z”}
{“level”:“verbose”,“message”:“photo.consolidate \u001b[90m#75\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:48:20.225Z”}
{“level”:“verbose”,“message”:“photo.update \u001b[90m#77\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:48:41.865Z”}
{“level”:“verbose”,“message”:“activity.update \u001b[90m#78(75) Δ22s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:48:41.901Z”}
{“level”:“verbose”,“message”:“photo.consolidate \u001b[90m#79(75) Δ22s\u001b[39m”,“label”:“project”,“timestamp”:“2018-05-31T14:48:41.904Z”}
{“level”:“warn”,“message”:“SLOW: photo.consolidate”,“label”:“project”,“timestamp”:“2018-05-31T14:48:41.908Z”}

2

Thanks for the suggestion of supporting different sort orders for photos within an item; we’ll make a note of it. Meanwhile, please note that you can re-arrange the photos within the item in any order you prefer by dragging them around (in case you were not aware of it already).

1250 photos should not slow down Tropy normally. However, the slowness is also apparent in your log file and the SQL time out. Could you give me an idea what hardware and which version of windows you’re using? The windows file system tends to be slower (when compared to our Linux and macOS test environments) so we might have to tune Tropy on Windows with older hardware specifically if we want to improve this.

3

I am using windows 8 64 bits, I have 4G ram, 1,7 Ghz for my processor with 4 CPUs. I have pretty good devices I think.

The message I got every time I launch TROPY is “[name of my project] Ressource Request timed out” and then I have to relaunch it.

Things are always slower on Windows, I will consider changing this!
Thks for the support

4

Hmm, yes, that should be fine. Is your hard disk formatted using NTFS or something else?

5

Hi, (sorry for the delay!)

Yes my hard disk is a NTFS-formatted one. When I saw your answer I remembered defragmenting my harddisk using windows. Now I just defragmented it with another software, “defraggler” from Piriform. After reboot, Tropy runs a little bit faster than usual. Almost all the photos finally “appear” in the item view, however it seems to represent huge efforts for the software (about 3 or 4 seconds of delay but it’s still something!). It goes the same way with my other 750-photos project.

Thanks for your help already, and thanks in advance for advices so that TROPY runs a little bit faster on Windows

6

Hi once again,
I was wondering, in order to lighten TROPY and to be able to use it faster, is it better to add a lot of lists and items so that the software doesn’t have to treat high numbers of photos in the same time, or is it better not to?
Thanks in advance!

7

Tropy only renders approximately two screens of items in the item table / grid view, so the total number of items should not make a big difference to rendering speed. If you’re still seeing database timeout errors, these are caused by queries which are not optimized sufficiently for a large projects (again, 750 items should not count as a large project at all, which is why I was guessing there were issues reading from the disk originally).

Your C: drive is not an SSD, right?

8

Thanks for your answer.
Yes, my drive si an SSD. However TROPY is on a first disk, C, my photos are on a second one, E. You think it might have an influence?

9

It would be interesting to know if there is a noticeable improvement if you move the project file to drive E. Note that it should be no problem to move around the project file (the .tpy file) – the only thing that Tropy does not find it automatically at start up after you move it.

10

No noticeable changes!