0x2620/pandora
2
1
Fork 1
Code Issues 1.3k Pull requests Releases Wiki Activity

Speed up loading items with many (entity) annotations #2830

New issue
Closed
opened 2015-09-09 14:32:21 +00:00 by wjt · 3 comments
wjt commented 2015-09-09 14:32:21 +00:00
Copy link

In the latest chapter of this developing saga, here's a pair of patches which makes a visible difference to loading big scenes:

  1. use select_related('user') for items, just like (static) edits.
  2. cache serialized entities for the common case where many annotations reference the same entity. This patch is a bit more questionable, I think you'd be totally justified in asking me to go away and actually fix the schema :-)
In the latest chapter of this developing saga, here's a pair of patches which makes a visible difference to loading big scenes: 1. use select_related('user') for items, just like (static) edits. 2. cache serialized entities for the common case where many annotations reference the same entity. This patch is a bit more questionable, I think you'd be totally justified in asking me to go away and actually fix the schema :-)
j added the
general
 label 2015-09-09 14:32:21 +00:00
j added this to the 14.04 milestone 2015-09-09 14:32:21 +00:00
0x2620 was assigned by j 2015-09-09 14:32:21 +00:00
j added the
normal
defect
 labels 2015-09-09 14:32:21 +00:00
wjt commented 2015-09-09 14:52:28 +00:00
Author
Copy link

Attachment 0001-Combine-Item-Clip-edit.Clip-.get_layers.patch (6062 bytes) added

**Attachment** 0001-Combine-Item-Clip-edit.Clip-.get_layers.patch (6062 bytes) added
0001-Combine-Item-Clip-edit.Clip-.get_layers.patch
5.9 KiB
wjt commented 2015-09-09 14:52:35 +00:00
Author
Copy link

Attachment 0002-Cache-serialized-entities-when-fetching-many-annotat.patch (4877 bytes) added

**Attachment** 0002-Cache-serialized-entities-when-fetching-many-annotat.patch (4877 bytes) added
0002-Cache-serialized-entities-when-fetching-many-annotat.patch
4.8 KiB
j commented 2015-09-14 12:10:56 +00:00
Owner
Copy link

fixed in []changeset:pandora,5020

fixed in []changeset:pandora,5020
j added the
fixed
 label 2015-09-14 12:10:56 +00:00
j closed this issue 2015-09-14 12:10:56 +00:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
stable
No results found.
Labels
Clear labels   
backend

   
critical

   
defect

   
duplicate

   
enhancement

   
fixed

   
frontend

   
general

   
invalid

   
major

   
minor

   
normal

   
oxjs

   
pandora_client

   
python-ox

   
task

   
trivial

   
wontfix

   
worksforme
No labels
backend
critical
defect
duplicate
enhancement
fixed
frontend
general
invalid
major
minor
normal
oxjs
pandora_client
python-ox
task
trivial
wontfix
worksforme
Milestone
Clear milestone
No items
No milestone
14.04
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
0x2620
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: 0x2620/pandora#2830
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?