SteveGrose <[log in to unmask]> wrote:
>
>I have a couple questions about Visual Basic and Image Sql. I'm fairly new
>to both.
>
>I'm using Visual Basic to access Image databases via ODBC. The set I'm
>(snip)
>The above example took 2 Hours 45 Min on a 937 with 30 account types.
>
>The problem with the above, as I see it, is out of the 100,000 records in
>the trans set maybe 5,000 records are for 1994. Each time I cycle though
>to sum the account types, I look though 100,000 records instead of the
>5,000.
>
>What I think I'd to do is create a Snapshot of the transactions for 1994,
>then do all my account type queries on that snapshot. I've tried just
>about everything I can think of.
 
The good news, Steve, is that the 6.0 release of IMAGE/SQL will support
IMAGE keys and Third-party indexes.  These two capabilities will allow you
to access *only* the records you want (1994), instead of the whole set.
Also, it will run on the 5.0 MPE/iX OS.
 
The bad news is it's not here yet.  However, I understand it will be soon.
 
Larry Boyd