Join files

[lgronewold@xxxxxxxxxxxxxxxxxx]

I have a question on Join files:

    The first is on joining files.  I have two physical files that have been
    joined.  The first one is a customer master file that has one member and
    582363  total records (no deleted records).  The second file is a
control
    file that has 8 records (40 deleted records) and one member.  A join
logical
    was created over the two physical files.  The customer file is the first
    file and is joined to the second by customer number.  The files are
sorted
    by customer name and number.  In my program I allow the user to type in
the
    customer name.  I then set lower limits to the join file by the entered
    information and read it.  I then display information from the join.  The
    problem is that it takes over 5 minutes to display the information.
Does
    anyone have any suggestions on what the problem is?  Is a join a valid
    option in this program?  There was debate over the use of a join file.

Lori Gronewold
GBS Developer





***************************Disclaimer*************************** 
The contents of this e-mail and any file transmitted with it are confidential 
and intended solely for the individual or entity to whom they are addressed.  
The content may also contain legal, professional or other privileged 
information. If you received this e-mail in error, please destroy it 
immediately.  You should not copy or use it for any purpose nor disclose its 
contents to any other person. The views stated herein do not necessarily 
represent the view of the Company. Please ensure you have adequate virus 
protection before you open or detach any documents from this transmission. The 
Company does not accept any liability for  viruses.
Premier Farnell plc
150 Armley Road Leeds
LS12 2QQ
Telephone +44 (0) 870 129 8608
Fax +44 (0) 870 129 8610 
Registered in England
Company Number 876412
Registered Office: Farnell House, Forge Lane, Leeds LS12 2NE 
************************************************************