Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I just thought about using <em>any collection</em> similar to a <em>generic hashtable</em>... Something like this:</p> <pre><code>Dictionary&lt;string, YourClass&gt; dict = new Dictionary&lt;string, YourClass&gt;(); /// just let's assume you want to add/check for "c:\demo.txt" if (!dict.ContainsKey(@"c:\demo.txt")) { /// add items to dict by passing fullPath as key and your objects as value dict.add(@"c:\demo.txt", obj1); } else if (dict[@"c:\demo.txt"].CheckForIntervall()) { /// replace current object in dictionary with new object - in case you want to.. /// or just do what you want to } </code></pre> <p>edit - your custom class may have some functionality like this:</p> <pre><code>class YOURCUSTOMCLASS { private DateTime creationTime; public DateTime CreationTime { get { return creationTime; } } public YOURCUSTOMCLASS(parametersGoesHere xyz) { creationTime = DateTime.Now; } /// in this case this method will return true /// if the timeSpan between this object and otherObject /// is greater than 4 seconds public bool CheckForInterval(YOURCUSTOMCLASS otherObject) { TimeSpan diff = otherObj.CreationTime.Subtract(creationTime); /// you may replace 4 through any other digit, or even better take /// a const/global var/static ... return diff.TotalSeconds &gt; 4; } /// all the other stuff you need ... } </code></pre> <p>Of course you will <em>loose the functionality of a queue</em> - but you will get an <strong>massive increase in runtime</strong> if your queue containts many elements.</p> <p>hth</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to remove duplicate items from a queue within a time frame?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPilgerstorfer Franz
    1. USPilgerstorfer Franz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to remove duplicate items from a queue within a time frame?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COyou don't need to check for the existence of the key. You can just remove that check and make dict.add be dict[key] = "demo.txt" and you will result in the same thing but just a little cleaner.
      singulars
      1. PO
      1. USphillip
    2. COThis is what I am basically doing with the dictionary already but locking the dictionary and limiting it to n rows. I am interested in the CheckForInterval() and how you would do that.
      singulars
      1. PO
      1. USuser610064
    3. CO@philip - of course you are right - in the original question there was an additional task - that an existing object may just be added/replaced in case if the given interval is timed out. @user610064 I'll will have a further look into it an respond in a few minutes
      singulars
      1. PO
      1. USPilgerstorfer Franz
 

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