Project

General

Profile

Actions

Support #3355

open

substack direct queries

Added by Gabriel Lander about 9 years ago.

Status:
New
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Start date:
08/12/2015
Due date:
% Done:

0%

Estimated time:
Affected Version:
Appion/Leginon 3.2

Description

Replaced sinedon-based query & insertion for substacks with direct SQL. Significant speedup.
Tested by making 500,000 particle substack of 524,371 stack:

Sinedon query: 8 min 42 sec
Sinedon insertion: 7 days 8 hrs

Direct query: 53 sec
Direct insertion: 1 min 52 sec


Related issues 1 (0 open1 closed)

Related to Appion - Bug #3521: commitSubStack function gives mysql syntax error due to using direct mysql insertClosedGabriel Lander09/01/2015

Actions
Actions #1

Updated by Anchi Cheng about 9 years ago

  • Related to Bug #3521: commitSubStack function gives mysql syntax error due to using direct mysql insert added
Actions

Also available in: Atom PDF