Project

General

Profile

Actions

Bug #4699

open

Querying database for preset 'xxxx' images from session 'xxx' ... is VERY SLOW

Added by Neil Voss almost 8 years ago.

Status:
In Code Review
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Start date:
01/11/2017
Due date:
% Done:

0%

Estimated time:
Affected Version:
Appion/Leginon 3.2
Show in known bugs:
No
Workaround:

Description

I was testing and the

Querying database for preset 'xxxx' images from session 'xxx'

was taking a long time
 ... Found 8 images in 26.3 sec

I located the problem to the original query. It was search all presets with the same name, e.g., en, which would return thousands of results. It is fixed to only grab preset from a particular session and the new time is:

 ... Found 8 images in 14.62 msec

see commit:03ef58ad


Related issues 1 (0 open1 closed)

Related to Appion - Bug #4709: apDatabase.py update buggyClosedGabriel Lander01/15/2017

Actions
Actions #1

Updated by Neil Voss almost 8 years ago

  • Related to Bug #4709: apDatabase.py update buggy added
Actions

Also available in: Atom PDF