AVR-Chat

At 09:40 PM 7/15/04 +0000, you wrote:
>--- In AVR-Chat@yahoogroups.com, Robert Adsett <subscriptions@a...>
>wrote:
> > Speaking of small amounts of data, have you checked to see how your
> > analysis program responds to the amount of data you've been talking
>about yet?
>
>No.
>
>The most likely candidates will be a spreadsheet or an Access
>database.
>The most common use will be to print a full graph and then sections
>of interesting parts of it.

Definitely check real soon now.  I strongly suspect this will limit your 
data collection more than your ability to store it locally as you collect 
it.  I've used both 1-2-3 and Excel for those (And Quatro many moons 
ago).  I have a ~2000 row item in a 1-2-3 spreadsheet and it takes a few 
seconds to create a graph from that (not bad really).  I've done some with 
Excel and it took longer than that for a few hundred points (not 
necessarily a fair comparison, 1-2-3 had more memory available, Excel was 
on a faster processor).  From what I've seen/heard Access would be a bad 
choice for this.  It's a database and this really isn't a database 
application (you never want to perform a lookup on the data).

The version of 1-2-3 I'm using has a row limit of ~8K items, Excel 2003 
spec claims 64K rows.  In any case create a maximum size data file and see 
how it behaves.  Usually at some boundary even if the data fits performance 
will drop dramatically (what used to take seconds takes minutes or even 
hours).  You will want to know if you are going to hit that boundary.

Memory constraints may slow it down more than processor speed.

Robert

" 'Freedom' has no meaning of itself.  There are always restrictions,
be they legal, genetic, or physical.  If you don't believe me, try to
chew a radio signal. "

                         Kelvin Throop, III