Databases
StackOverflow2013
Postsdbo
POSaving and Loading Dictionary. Improving Memory Footprint
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSaving and Loading Dictionary. Improving Memory Footprint
    primarykey
    data
    text
    <p>Long time watcher and this is my first post so please go easy on me. I've looked around but my query is quite specific and I can't find it elsewhere.</p> <p>I have an application which consists of 2 controls. </p> <ul> <li>A control on the left contains a tree view which displays searches mapped from an XML file. Each Search has an associated GUID. </li> <li>A control on the right displays a datagrid, the information of which I obtain from the tree view through a Dictionary (Guid&lt;->Dataset).</li> </ul> <p>When the user clicks on a node in the tree view, my application works out which GUID the search is linked with and presents the associated dataset which gets flattened and displays on the datagrid.</p> <p>I save(Serialise) and load(Deserialise) the Dictionary when exiting/loading the application respectively.</p> <p>I did some memory profiling recently and for larger searches the memory footprint of the Dictionary can be quite large (200mb) for the limited capacity of the user machines which I really need to sort out.</p> <p>I was wondering if anyone had any idea how to achieve this.</p> <p>I was thinking about splitting the Serialisable Dictionary into constituent Datasets and storing each one individually on the hard drive (maybe with the GUID as the filename). The saved Datasets would then be deserialised with each Node.Click event and displayed in the grid view. My worry about this is the potential pause in between each click event as it saves the old search and loads a new one.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USrekenerd
    1. USRaza
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSaving and Loading Dictionary. Improving Memory Footprint
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSaving and Loading Dictionary. Improving Memory Footprint
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POSaving and Loading Dictionary. Improving Memory Footprint
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you show us the code?
      singulars
      1. POSaving and Loading Dictionary. Improving Memory Footprint
      1. USEnigmativity
    2. COWhat code do you want to see Enigmativity? There is quite a bit up there covering different aspects of the application.
      singulars
      1. POSaving and Loading Dictionary. Improving Memory Footprint
      1. USRaza
    3. COJust the code that illustrates what's going on in your question. If we can see the essence of your code we might be able to provide better help.
      singulars
      1. POSaving and Loading Dictionary. Improving Memory Footprint
      1. USEnigmativity
 

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