Re: Embedded Database Recommendations?

Paul Carpenter <paul@xxxxxxxxxxxxxxxxxxxxxxxxxxx> writes:

Hmm my working gateway email server uses mySQL, originally on a sub GHz
processor and 256MB of RAM, Got upgraded to a newer nano-ATX board
1GHz and 1GB RAM. System runs Apache and email server and several other
apps, some of them using the half dozen databases.

Thanks, all good information.

However the system is so lightly loaded, the real question on SELECT
speeds and memory footprint depends on

Size and complexity of database
Number of concurrent users (access to database)
Number of SELECT requests per min/per hour...
What forms of caching are being used
etc....

The database will be large (e.g. tables of 1,000,000 or more entries),
but not particularly complex.

There weill only be one application accessing the database at a time
(or at all).

Assuming only one (concurrent) connection, I wonder why the number of
select requests per time period is a factor (it clearly will be for
multiple connections).

I suppose what I'm looking for is how long it takes to do:

SELECT * FROM SomeTable WHERE SomeField = 'SomeValue'

and SomeField is the primary key. By "how long" I mean mean, standard
deviation, and [if possible] worst case times.

Ciao,

Peter K.

--
"And he sees the vision splendid
of the sunlit plains extended
And at night the wondrous glory of the everlasting stars."


.

Relevant Pages

  • Re: performance optimization?
    ... need more RAM. ... Only if your machine is IO limited by your hard drives does it make much ... I do run database software and even with that I have ... # semaphore maximum value: 32767 MAX ...
    (comp.os.linux.misc)
  • Re: out of memory
    ... read only the smaller file into a hash. ... the smaller file will fit into RAM. ... Depending upon the sorting algorithm this would be Ologor ... put your relevant data into a database and use ...
    (comp.lang.perl.misc)
  • ANN: NexusDB Breaks the 2GB database RAM cache barrier
    ... Your customer has a huge database with many gigabytes of data. ... Unfortunately, because RAM for the ... You could for instance run NexusDB Server AWE ... The best part of the NexusDB Serer AWE edition is that it is a drop-in ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Embedded Database Recommendations?
    ... 1GHz and 1GB RAM. ... Number of concurrent users (access to database) ... Number of SELECT requests per min/per hour... ... so determines how fast a storage unit, ...
    (comp.arch.embedded)
  • Re: card catalog program?
    ... disk files that have databases related to book libraries. ... 768K of RAM at the time. ... by Appleworks with a 1MB RAMworks-style memory card and AE's Appleworks ... wonder how many could fit in memory for a standard-size database ...
    (comp.sys.apple2)