Re: Substitute for database table ?

Matt,
I'm not sure I follow your descriptions or if they correspond to what
I've got but I suspect that your assessment won't change if I just ask
you to confirm on this recap......
I'd have a table of several thousand rows and, say, four columns - I've
a value which I want to find but I don't know which column it'll be in
- I need to know the other values of the row (and which columns they're
in) so I'm looking for the row, obviously.

To improve the performance I'd put indexes on all the columns. I don't
think I'm interested in any sort of key. I'm not sure what you mean by
'the n-ary position'.

There is another scenario where I know what column the value should be
in which is more straightforward.

I just thought that maybe having something in memory would make it
quicker and lighter and that a DBMS would be a sledgehammer for a
relatively small nut. Your comment about the volume of data relates to
how much memory I'd need I suppose.

Ian

.

Relevant Pages

  • Re: Memtest86+, ver, 1.65
    ... >>>If you have a system not working properly and you suspect component A is ... > And measurements taken by a defective system tell you what about a component? ... > But replacing a component does not test the component that is no longer ... Memory timings, cacheing, pipelining, read-around, etc. ...
    (alt.comp.hardware.pc-homebuilt)
  • Stop code on install - followup
    ... I was receiving a radio station on the stereo. ... the problem was alleviated to some degree, but with severe memory limits, the system runs out of memory easily and stops. ... The original problem was due to interference from the FM into the giga-byte motherboard, which ran at about 100mhz/133mhz on the memory (radio station on 107.9). ... The data gleaned from msdn as well as win 2k kb does make the HDD/IDE controller a suspect though. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: When do you turn off your Ubuntu boxes?
    ... You must understand that I am quite ancient and my memory goes back to ... the days before transistors were invented. ... I agree that the quality if components can be suspect at times. ...
    (Ubuntu)
  • Re: Ask EU: Registry cleaners
    ... MiL's PC is terribly slow - I suspect it needs more memory, but thought I'd check other stuff as well... ... Ccleaner has a registry cleaner which doesn't seem to have done me any harm, though not sure whether it's made me any faster. ...
    (uk.media.radio.archers)
  • Re: Ruby on Unix vs. Windows
    ... That's what I suspect as well. ... It's a SIP protocol analyzer and it builds SIP call flows in memory ... Rick Nooner ...
    (comp.lang.ruby)