Home » STAR Publications » Categories

Database load times

Updated on Fri, 2007-10-12 11:45. Originally created by kocolosk on 2007-10-09 22:52.
Here's a sample breakdown of the time it takes to initialize each of the databases we use in STAR:
Calibrations_eemc.......Real time 0:00:00.101, CP time 0.050
Calibrations_emc........Real time 0:00:00.045, CP time 0.010
Calibrations_ftpc.......Real time 0:00:00.005, CP time 0.000
Calibrations_l2.........Real time 0:00:00.014, CP time 0.000
Calibrations_l3.........Real time 0:00:00.013, CP time 0.000
Calibrations_pmd........Real time 0:00:00.019, CP time 0.010
Calibrations_rhic.......Real time 0:00:00.004, CP time 0.000
Calibrations_rich.......Real time 0:00:00.004, CP time 0.000
Calibrations_ssd........Real time 0:00:00.012, CP time 0.010
Calibrations_svt........Real time 0:00:59.828, CP time 0.490
Calibrations_tof........Real time 0:00:00.054, CP time 0.020
Calibrations_tpc........Real time 0:00:00.845, CP time 0.030
Calibrations_tracker....Real time 0:00:00.018, CP time 0.000
Calibrations_trg........Real time 0:00:00.004, CP time 0.000
Calibrations_zdc........Real time 0:00:00.005, CP time 0.000

Geometry_emc............Real time 0:00:00.030, CP time 0.010
Geometry_ftpc...........Real time 0:00:00.051, CP time 0.000
Geometry_pmd............Real time 0:00:00.117, CP time 0.010
Geometry_ssd............Real time 0:00:00.026, CP time 0.000
Geometry_svt............Real time 0:00:06.470, CP time 0.090
Geometry_tof............Real time 0:00:00.033, CP time 0.000
Geometry_tpc............Real time 0:00:00.326, CP time 0.010

Conditions_trg..........Real time 0:00:00.021, CP time 0.020

RunLog_l3...............Real time 0:00:00.022, CP time 0.000
RunLog_onl..............Real time 0:00:00.019, CP time 0.000
RunLog_rhic.............Real time 0:00:00.005, CP time 0.000

StarDb..................Real time 0:03:39.359, CP time 0.710
I'm a little confused by the fact that StarDb is not equal to the sum of all the other tables, but the breakdown clearly indicates that the SVT tables take up far more time than all the other listed tables combined.  If we could find a way to turn off loading of those tables it would be a great help to people doing code development (and would likely take some load off the DB servers as well).  I understand Yuri is working on something in this department, but I'm not sure how far along it is.

UPDATE

I repeated this test again and found that this time StarDb ~ Calibrations_svt:
Calibrations_svt........Real time 0:05:56.508, CP time 0.460
Geometry_svt............Real time 0:00:16.197, CP time 0.080
StarDb..................Real time 0:06:17.437, CP time 0.630

MY HACK

After a bit of digging I found that one can skip the SVT tables by adding the following line to the beginning of StDbConfigNodeImpl::buildTree:
// Skip SVT tables for performance boost -- APK
if( mdbDomain == dbSvt ) return 1;
I've made this hack available in ~kocolosk/fastDbLib. I can't guarantee it won't have side-effects, but with DB load times reduced to < 1 second I think it's worth a shot.

MY HACK, VERSION 2

I missed some recursion in the first hack; this seems to do a better job:
// Skip SVT tables for performance boost -- APK
if( mdbDomain == dbSvt ) {
if(mnextNode)mnextNode->buildTree(opt);
return 1;
}
»

AOB

Updated on Tue, 2007-10-09 20:45. Originally created by shenminh on 2007-10-09 20:45.

Reference

Speaker : All


Talk time : 00:25, Duration : 00:05

Update/few words on L2 debugging progress

Updated on Tue, 2007-10-09 20:45. Originally created by shenminh on 2007-10-09 20:45.

Reference

Speaker : Mike


Talk time : 00:20, Duration : 00:05

Progress on the proposal

Updated on Tue, 2007-10-09 20:44. Originally created by shenminh on 2007-10-09 20:44.

Reference

Speaker : All


Talk time : 00:10, Duration : 00:10

Progress on testing the ladders

Updated on Tue, 2007-10-09 20:43. Originally created by shenminh on 2007-10-09 20:43.

Reference

Speaker : All


Talk time : 00:00, Duration : 00:10

Physical Review D

Updated on Tue, 2007-10-09 18:40. Originally created by chajecki on 2007-10-09 18:40.
Short Title:Phys. Rev. D
Home Page:http://prd.aps.org/
Article URL Prefix:http://link.aps.org/abstract/PRD/

Journal of Physics G: Nuclear and Particle Physics

Updated on Tue, 2007-10-09 18:39. Originally created by chajecki on 2007-10-09 18:39.
Short Title:J. Phys. G
Home Page:http://www.iop.org/EJ/journal/JPhysG
Article URL Prefix:http://www.iop.org/EJ/abstract/

Nuclear Physics A

Updated on Tue, 2007-10-09 18:37. Originally created by chajecki on 2007-10-09 18:37.
Short Title:Nucl. Phys. A
Home Page:http://www.elsevier.com/
Article URL Prefix:http://dx.doi.org/10.1016/

Physics Letters B

Updated on Tue, 2007-10-09 18:36. Originally created by chajecki on 2007-10-09 18:36.
Short Title:Phys. Lett. B
Home Page:http://www.elsevier.com/
Article URL Prefix:http://dx.doi.org/10.1016/

Physical Review C

Updated on Tue, 2007-10-09 18:36. Originally created by chajecki on 2007-10-09 18:36.
Short Title:Phys. Rev. C
Home Page:http://prc.aps.org/
Article URL Prefix:http://link.aps.org/abstract/PRC/

Physical Review Letters

Updated on Tue, 2007-10-09 18:35. Originally created by chajecki on 2007-10-09 18:35.
Short Title:Phys. Rev. Lett.
Home Page:http://prl.aps.org/
Article URL Prefix:http://link.aps.org/abstract/PRL/

Technical

Updated on Tue, 2025-05-20 14:03 by testadmin. Originally created by chajecki on 2007-10-09 18:30.

Moderators of Technical category of STAR Publications
jhlee
mogavero
sprastar

Computing

Updated on Thu, 2023-11-02 13:37 by testadmin. Originally created by chajecki on 2007-10-09 18:29.

Moderators of Computing category of STAR Publications
dmitry
dongx
iraklic
jwebb
taknn

PWG

Updated on Tue, 2023-05-02 12:01 by testadmin. Originally created by chajecki on 2007-10-09 18:29.

Moderators of PWG category of STAR Publications
rksooraj
trzeciak

Round table: jet finding in Heavy Ion collisions (status, plans, strategy)

Updated on Sat, 2007-10-13 17:49. Originally created by mvl on 2007-10-09 17:39.

Reference

Speaker : Joern Putschke, Sevil Salur, Dylan Thein


Talk time : 11:00, Duration : 01:00

...

Updated on Sat, 2007-10-13 17:51. Originally created by mvl on 2007-10-09 17:38.

Reference


Talk time : 10:45, Duration : 00:15

pi0-hadron azimuthal correlations in Au+Au

Updated on Sat, 2007-10-13 17:47. Originally created by mvl on 2007-10-09 16:48.

Reference

Speaker : Essam Elhalhuli


Talk time : 10:00, Duration : 00:45

High-pt parallel session

Updated on Mon, 2007-10-15 16:30. Originally created by mvl on 2007-10-09 16:28.
TimeTalkPresenter
10:00pi0-hadron azimuthal correlations in Au+Au ( 00:45 ) 0 filesEssam Elhalhuli
10:45... ( 00:15 ) 0 files
11:00Round table: jet finding in Heavy Ion collisions (status, plans, strategy) ( 01:00 ) 0 filesJoern Putschke, Sevil Salur, Dylan Thein

9 GeV event example with vertex 4

Updated on Tue, 2007-10-09 16:14. Originally created by psoren on 2007-10-09 16:14.
9 GeV event example with vertex 4

9 GeV event example with vertex 3

Updated on Tue, 2007-10-09 16:13. Originally created by psoren on 2007-10-09 16:13.
9 GeV event example with vertex 3

Another with a vertex