Re: Access & Scaling

Don, this isn't quite clear to me.  The data in both instances resides on the 
AS/400?  In fact is the same data? You have an interactive SQL product that 
interctively reads a record at a time, is that right?  (btw, is SQL a product 
or is it a technique?) Access is just reading and displaying records in arrival 
order?  In other words, is one method chunking blocks and the other processing 
random records?



In <6158311305011999/A13130/TIMONE/11D12B5F3A00*@MHS>, on 01/05/99 
   at 08:31 AM, Don Schenck <schencd%AM_LZCH%VASELL@mr.mops.wl.com> said:


>I took a table with 104000+ records. I scrolled down for ten seconds. The
>results:

>AS/400, using Interactive SQL to scroll: 241 records
>Access, using a "tableview" to scroll: 2848 records


>So I guess it's not Access that is the dog; it's the hardware platform!
>In this case, the AS/400 is underpowered. Then again ... it costs how
>much compared to the 400MHz NT machine I'm using here?

-- 
-----------------------------------------------------------
boothm@ibm.net
Booth Martin
-----------------------------------------------------------

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---