Changes between Version 16 and Version 17 of Processing_Throughput

Timestamp:

Sep 20, 2011, 2:36:20 PM (15 years ago)

Author:

watersc1

Comment:

--

Processing_Throughput

@@ -7 +7 @@
    * ccdtemp queries running rampant? Chris looking into if necessary and removing. 
      * FPA.TEMP concept was being drawn from the database, instead of the image headers.  This seems to have been unnecessary for a long time, and switching back to a header based value does not appear to have any effect on the images or photometry for a small sample.  Removing these calls to the database have cut the load from 15-20 to ~3, largely removing potential database load issues from the list of possible bottlenecks.
-
+   * It appears mysql supports SQL_CACHE and SQL_NO_CACHE hints on select statements.  If we are needlessly filling memory with cached queries that will never be repeated, we can flag this as such, and see if this helps.  Similarly, hinting that load-like statements (select * from blahRun where state = 'new';) should be cached may help as well.
+ 
  * Polling times/rates: are the polling rates causing extra load and delay with DB queries unnecessarily?
    * Bill testing by changing times in update