Dave,
Thanks for your reply.We will be running for about 8 hours a day, hence the
300K figure. I hadn't considered overheads though. The data is question will
be read in in blocks of 8 bytes at a time from a PIC, where the first byte
can be discarded at it is an identifier. ie. firstly we'll get a*******, and
then b*******. All we want is the stars. I presume this can be placed in a
single 16 byte record. Is this an effective use of the database though; only
one record?
Also, what are the time overheads for writing a database record. It must be
low, otherwise we will have to re-think. Your help would be appreciated.
Stuart Norton
-----Original Message-----
From: Dave Lippincott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 29, 1999 6:23 PM
To: [EMAIL PROTECTED]
Subject: Re: Database advice
I'd say it depends on the type of the variables that make up your 16 bytes.
Plus, logging 16 bytes every 2 secs for 24hrs is a allot more than 300K.
24hrs x 60min/hr x 30readings/min x 16bytes/reading = 675K.
..
.
