Database load times

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

Speaker : All


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

Update/few words on L2 debugging progress

Speaker : Mike


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

Progress on the proposal

Speaker : All


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

Progress on testing the ladders

Speaker : All


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

Physical Review D

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

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

Short Title:Nucl. Phys. A
Home Page:http://www.elsevier.com/
Article URL Prefix:http://dx.doi.org/10.1016/

Physics Letters B

Short Title:Phys. Lett. B
Home Page:http://www.elsevier.com/
Article URL Prefix:http://dx.doi.org/10.1016/

Physical Review C

Short Title:Phys. Rev. C
Home Page:http://prc.aps.org/
Article URL Prefix:http://link.aps.org/abstract/PRC/

Physical Review Letters

Short Title:Phys. Rev. Lett.
Home Page:http://prl.aps.org/
Article URL Prefix:http://link.aps.org/abstract/PRL/

Technical


Moderators of Technical category of STAR Publications
jhlee
mogavero
sprastar

Computing


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

PWG


Moderators of PWG category of STAR Publications
rksooraj
trzeciak

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

Speaker : Joern Putschke, Sevil Salur, Dylan Thein


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

...

pi0-hadron azimuthal correlations in Au+Au

Speaker : Essam Elhalhuli


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

High-pt parallel session

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

9 GeV event example with vertex 4

9 GeV event example with vertex 3

9 GeV event example with vertex 3

Another with a vertex