Database in memory

Hi,

I have a large amount of information which I store in memory. I store
this information as array of structures using CPtrArray. The structure
is pretty complex, has subarrays.

I normally iterate through all of the array and do some checks and
process the needed information only. Speed is the keypoint.

My question is: Is it possible to create a small database having
several tables completely in memory and query it with SQL? If it is
possible to manage that, will it be faster than my method of query?

Thanks!

.

Relevant Pages

  • Re: Is this a good idea?
    ... > in memory - induces lazyness in the programmers. ... Lazyness leads to more ... A typical database query will return 10K ... To say that reading the data into an array would somehow have ...
    (comp.lang.php)
  • RE: runtime error record is deleted
    ... I want to split the fields to store in a table. ... the field to a function that splits the fields into an array: ... Query: SELECT splitname, first, last, ... Dim rs As ADODB.Recordset ...
    (microsoft.public.access.queries)
  • Re: Storing large number of values in 2D array
    ... array.How can I store them and retrieve them later? ... around 32 000 bytes for the 2D array. ... But that was a memory efficient solution, ... I have seen proposals to add to C ...
    (comp.lang.c)
  • Re: A challenging file to parse
    ... algorithm problem and found a Orun-time and Omemory solution, ... Do the same thing, but when storing in an array, store it at ...
    (comp.lang.c)
  • Re: Database in memory
    ... > I have a large amount of information which I store in memory. ... > this information as array of structures using CPtrArray. ... > several tables completely in memory and query it with SQL? ...
    (microsoft.public.vc.mfc)