4 Replies Latest reply on Jun 9, 2017 5:43 AM by fmanniti RSS
    fmanniti Creator

    Where infotable data is stored?

    Hello,

    would you please help me with a memory issue that I have?

     

    I have a stream with some data which covers a certain amount of time (let's say one year).

    The user must query a period from that year, get data, make calculus and plot the results.

    If I do this runtime it may take a while to do the calculus (like 3 or 4 seconds) because there are stored thousands of rows and if I have to switch to one thing to another from the list it could be "ugly" if it takes 3 or 4 seconds any time I change item plus, more important, CPU overworks.

    One more thing is that there are multiple users working on the same virtual machine so it can be even worse.

    My clue was to set a property for each thing with INFOTABLE as basetype so anytime I make a search, my service fills this property with the result and my plot is on the property instead of the service result.

    In this case, the calculus is done only once and not anytime I switch item from the list.

    Now I was wondering: where these Infotable data are stored? In the RAM? Becuse in that case I will have another problem of memory if I have a lot of things.

     

    I hope my question is clever enough.

    Thank you