Re: Database in memory

Have a look at http://sqlite.org/
I use it in a couple of the things I work on and so far it has been a
joy to work with.

bumbala@xxxxxxxxx wrote:
> 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)
  • 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)