aka.sps

About

Username
aka.sps
Joined
Roles
Member

Comments

  • Just FYI: Define New Collating Sequences (during database connection) http://www.sqlite.org/c3ref/create_collation.html Possible UNICODE LIKE, upper(), lower() function solution https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg…
    in Sorting items list: Out of memory Comment by aka.sps September 17, 2019
  • The answer to the last question: 32GB. Unfortunately, in Windows your application is 32bit, so the maximum observed memory footprint was about 3.2GB. Page Fault Rate - 4,000-90,000 per second, w/o disk activity. I just draw your attention to the bo…
    in Sorting items list: Out of memory Comment by aka.sps September 17, 2019
  • Yes, the books in this group are interconnected, have a common numbering and common tags. There are no subordinate elements, only the registration data of the book, as in the old library card index. This is a normal, real, not a toy situation. And …
    in Sorting items list: Out of memory Comment by aka.sps September 16, 2019
  • Fix: CREATE INDEX IF NOT EXISTS "itemTags_tagID_type_idx" ON "itemTags" ("tagID" ASC, "type" ASC); Adding the index significantly reduces the query execution time (~200 times) (4)(+0000001): SELECT DISTINCT name AS tag, type FROM itemTags JOIN ta…
    in Slow tag loading in Zotero 5.0 Comment by aka.sps November 10, 2017
  • Debug ID D1648264797 Problem is not fixed. Too slow navigation. (4)(+0000001): SELECT DISTINCT name AS tag, type FROM itemTags JOIN tags USING (tagID) WHERE itemID IN ([...44904]) (3)(+0067273): Refreshing tags selector Possible, it is a result of…
    in Slow tag loading in Zotero 5.0 Comment by aka.sps November 10, 2017
  • Hi, You can see in log (Debug ID is D77483814) that each navigation to collection with big number of items take significant time. Navigation to root of library take 1 minute. Each time. Note: It is impossible do not show full list. For example dou…
    in Slow tag loading in Zotero 5.0 Comment by aka.sps August 4, 2017
  • Hi, I'm using Zotero 5.0.7 also and I having the same problem. Full library list view take about 1 minute. Of course, I have about 30000 references but I do not have this problem with Zotero 4. The Debug ID is D77483814. IMHO problem is here: (4…
    in Slow tag loading in Zotero 5.0 Comment by aka.sps August 4, 2017