RE: RPG chain = ?? in VB

Ok,

That being the case.  You VB programmer is making a mistake in searching
through all the records in VB.

What he should be doing is telling the RDBMS what records he is interested
in.  There are two ways to do this:

1) The WHERE clause of an SQL statement
2) By calling a stored procedure that only returns the records he wants.

If you'd tell us what method he his using to access the iSeries data (OBDC,
ADO/OLE DB, or .NET) we could provide specific examples.

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: Angela Wawrzaszek [mailto:awawrzaszek@xxxxxxxxxxxxxxx]
> Sent: Tuesday, December 14, 2004 9:52 AM
> To: Midrange Systems Technical Discussion
> Subject: RE: RPG chain = ?? in VB
> 
> 
> It is accessing a file on an as400 database.   The majority 
> of the file
> modifications (add, deletes etc)  would be handled through our ERP
> package,  the VB app is just utilizing the data in a more 
> user friendly
> way for some of our end users.  So yes there are MANY apps that would
> not know to update the index file.
> 
> On the as400 there are index files  (called logicals)   that 
> contain the
> Key for searching this is what the as400 programs use to 
> quickly set the
> pointer at the record needed.  If these indexed files or 
> views are used
> in VB with the 'find'  will this accomplish the same thing.  It still
> seems to run very slow.  The files the VB app is going over 
> has close to
> 200,000 records in it.
> 
> 
> Angela Wawrzaszek
> IT Supervisor
> awawrzaszek@xxxxxxxxxxxxxxx
> (315) 258-4205
> 
> -----Original Message-----
> From: CWilt@xxxxxxxxxxxx [mailto:CWilt@xxxxxxxxxxxx] 
> Sent: Tuesday, December 14, 2004 9:29 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: RPG chain = ?? in VB
> 
> Where is the file the VB programmer is reading?
> 
> If on a PC flat file, then no not really.  That's why RDBMS are used.
> 
> You could as Michael suggest, build some sort of an index flat file
> consisting of the KEY and the file position of the record 
> containing the
> key
> in the original file.  This would be faster to search.  However, you'd
> have
> to ensure that records are not added/deleted outside of a program that
> knows
> to update the index file.  Additionally, updating the index file is
> another
> whole can of worms.
> 
> 
> 
> Charles Wilt
> iSeries Systems Administrator / Developer
> Mitsubishi Electric Automotive America
> ph: 513-573-4343
> fax: 513-398-1121
>  
> 
> > -----Original Message-----
> > From: Angela Wawrzaszek [mailto:awawrzaszek@xxxxxxxxxxxxxxx]
> > Sent: Tuesday, December 14, 2004 9:12 AM
> > To: Midrange Systems Technical Discussion
> > Subject: RPG chain = ?? in VB
> > 
> > 
> > In RPG you can use a chain, or setll etc to get to a position 
> > in a file
> > quickly.   In VB my programmer is using a Find.  This takes a 
> > very long
> > time over large files and the application is extremely slow.  
> >  Is there
> > not a quicker way to position the cursor at the correct spot in VB
> > similar to RPG?
> > 
> >  
> > 
> >  
> > 
> > Thankyou ahead of time...
> > 
> >  
> > 
> > Angela Wawrzaszek
> > 
> > IT Supervisor
> > 
> > awawrzaszek@xxxxxxxxxxxxxxx
> > 
> > (315) 258-4205
> > 
> >  
> > 
> > --
> > This is the Midrange Systems Technical Discussion 
> > (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> > 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> 
> 
> --
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>