Actions
Feature #5950
openFaster Way to Insert Particle Picks
Status:
In Test
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
08/16/2018
Due date:
% Done:
0%
Estimated time:
Updated by Sargis Dallakyan about 6 years ago
- Status changed from New to In Test
I've modified insertParticlePeaks in appionlib.apParticle.py so that it would insert particle peaks without quering database first. I've also added fastInsertParticlePeaks that does direct sql insert. Here some timing stats on a small test result that shows how much performance improvement to expect:
Original version:
... inserted 3 of 3 peaks into database in 16.97 msec
... inserted 5 of 5 peaks into database in 23.74 msec
Inserting without doing a query:
... inserted 3 of 3 peaks into database in 11.74 msec
... inserted 5 of 5 peaks into database in 15.13 msec
Inserting with fastInsertParticle:Peaks:
... inserted 0 of 3 peaks into database in 1.39 msec
... inserted 0 of 5 peaks into database in 1.91 msec
Actions