Improved Analyses loading

Improved Analyses loading

Jun 23, 2016. | By: Jake Ross

I finally succeeded in speeding up loading analyses from the database. In reality retrieval from the database is quite rapid (depending on network connection) but converting to DVCIsotopeRecordViews was time consuming. One earlier optimization was to limit the number of progress.change_message calls. change_message eventually calls Qt.QApplication.process_events which takes ~80ms each call. So loading of analyses was already penalized 80ms because of the progress bar. I will continue to investigate the progress window but a more significant speed up was achieved by eliminating the concept of an IsotopeRecordView. (eventually this model should be extended to the other record view classes).

So… the major change was to keep the session open when a SessionCTX is exited and to temporarily disable expire_on_commit when retrieving analyses. Since the analyses do not change in the database it is safe to disable expire_on_commit

Subscribe

Subscribe to this blog via RSS.

Categories

Dvc 1

Database 1

Sample 1

Sample prep 1

Recent Posts

Popular Tags

Dvc (1) Database (1) Sample (1) Sample prep (1)

About

New Mexico Geochronology Research Laboratory (NMGRL) is a world class Ar-Ar geochronology laboratory located at New Mexico Bureau of Geology and Mineral Resources. Pychron Labs, LLC is small scientific software consulting firm specializing in data acquisition and processing noble gas mass spectrometry analyses.

Social Links

Our Bunker

801 Leroy Place
87801, Socorro, NM
United States.