Databases
StackOverflow2013
Postsdbo
POClean up algorithm
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POClean up algorithm
    primarykey
    data
    text
    <p>I've made an C# application which connects to my webcam and reads the images at the speed the webcam delivers them. I'm parsing the stream, in a way that I have a few jpeg's per seconds.</p> <p>I don't want to write all the webcam data to the disk, I want to store images in memory. Also the application will act as a webserver which I can supply a datetime in the querystring. And the webserver must server the image closest to that time which it still has in memory.</p> <p>In my code I have this: </p> <pre><code>Dictionary&lt;DateTime, byte[]&gt; cameraImages; </code></pre> <p>of which DateTime is the timestamp of the received image and the bytearray is the jpeg. All of that works; also handling the webrequest works. Basically I want to clean up that dictionary by keep images according to their age.</p> <p>Now I need an algorithm for it, in that it cleans up older images.</p> <p>I can't really figure out an algorithm for it, one reason for it is that the datetimes aren't exactly on a specific moment, and I can't be sure that an image always arrives. (Sometimes the image stream is aborted for several minutes). But what I want to do is:</p> <ul> <li>Keep all images for the first minute.</li> <li>Keep 2 images per second for the first half hour.</li> <li>Keep only one image per second if it's older than 30 minutes.</li> <li>Keep only one image per 30 seconds if it's older than 2 hours.</li> <li>Keep only one image per minute if it's older than 12 hours.</li> <li>Keep only one image per hour if it's older than 24 hours.</li> <li>Keep only one image per day if it's older than two days.</li> <li>Remove all images older than 1 weeks.</li> </ul> <p>The above intervals are just an example.</p> <p>Any suggestions?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBenjamin
    1. USfrankhommers
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POClean up algorithm
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POClean up algorithm
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POClean up algorithm
      1. This table or related slice is empty.
      1. VTDownMod
    1. COI got my inspiration from the reply I marked as answer. At each new incoming image I run my clean-up routine. Per Queue I have specified an interval, if that interval is expired I get the eldest image from the more recent queue above, and clean up the ones which are too old for the queue being processed.
      singulars
      1. POClean up algorithm
      1. USfrankhommers
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload