Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re^2: A profiling surprise ...

by chexmix (Hermit)
on May 24, 2008 at 14:48 UTC ( #688304=note: print w/replies, xml ) Need Help??


in reply to Re: A profiling surprise ...
in thread A profiling surprise ...

"If I understand you correctly, you have a list of 500 data sets, where each set comprises 1 to 7 matrices of 1K x 1K values (bytes? ints?); your test run of 13 "observation numbers" yielded 51 query executions, so maybe there was an average of about 3 matrices per observation? (13 queries to get the lists of detectors per observation, plus 13 * 3 queries to get the matrices for three detectors, would come to 52 queries -- am I on the right track here?)"

Sortakinda. The main diff is that each chip/matrix/CCD might only have a few 'hits' on it. So what my two DB queries do is:

  1. for each observation number in the list, return the chips/CCDs that actually have hits;
  2. for each chip/CCD involved in that observation number, return the x and y value of each hit on the chip/CCD.

Hope that makes more sense. The crunching that follows iterates over the result sets ... but is decoupled from the DB calls.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://688304]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (3)
As of 2021-01-22 03:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?