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: 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.
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.
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
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;
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.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.Progress on the proposal
Updated on Tue, 2007-10-09 20:44. Originally created by shenminh on 2007-10-09 20:44.Progress on testing the ladders
Updated on Tue, 2007-10-09 20:43. Originally created by shenminh on 2007-10-09 20:43.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
jhleemogavero
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
dmitrydongx
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
rksoorajtrzeciak
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.Time | Talk | Presenter |
---|---|---|
10:00 | pi0-hadron azimuthal correlations in Au+Au ( 00:45 ) 0 files | Essam Elhalhuli |
10:45 | ... ( 00:15 ) 0 files | |
11:00 | Round table: jet finding in Heavy Ion collisions (status, plans, strategy) ( 01:00 ) 0 files | Joern Putschke, Sevil Salur, Dylan Thein |