IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 142 and Version 143 of ippToPsps


Ignore:
Timestamp:
Aug 3, 2011, 9:22:09 AM (15 years ago)
Author:
rhenders
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ippToPsps

    v142 v143  
    7373== dvoToMySQL ==
    7474
    75 For the special case where we have a 'locked' DVO database, i.e. one that is complete and will not grow any further, we can improve ippToPsps processing time by first generating MySQL tables that include all detection from DVO rather than just the detections-per-exposure (or stack) as above. For this we can use the dvoToMySQL tool.
     75For the special case where we have a 'locked' DVO database, i.e. one that is complete and will not grow any further, we can improve ippToPsps processing time by first generating MySQL tables that include all detections from DVO rather than just the detections-per-exposure (or stack) as above. For this we can use the dvoToMySQL tool, found [here]
    7676
    7777It may take a matter of days to convert a relatively small DVO database to MySQL, however, querying the MySQL database is hugely faster than accessing DVO directly, especially for regions of sky with a high density of detections, such as the medium deep fields. (This was seen when loading MD4 prior to the Boston meeting in May 2011. DVO access per exposure was 40 minutes, whereas, once imported to MySQL, query time was roughly 30 seconds.)