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