[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1_v30

Title:*OLD* ALL-IN-1 (tm) Support Conference
Notice:Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:IOSG::PYE
Created:Thu Jan 30 1992
Last Modified:Tue Jan 23 1996
Last Successful Update:Fri Jun 06 1997
Number of topics:4343
Total number of notes:18308

1576.0. "Using BIND with alternate keys" by HOTAIR::MADDOX (Politicians say the darnedest things) Thu Oct 08 1992 00:41

    There is a conversation in ALL-IN-1_V24 (note 2386) which talks about
    the inefficiencies of using BIND with alternate keys.  Is this still a
    problem?  If it has been resolved is there a fix for 2.4?
    
    Thanks,
    
    Joe
T.RTitleUserPersonal
Name		DateLines
1576.1SIOG::T_REDMONDThoughts of an Idle MindThu Oct 08 1992 11:094
    Fixed (deep in code) in V3.0.  No fix available for V2.4.  Use
    BIND/SORT as a sort of workaround...
    
    T
1576.2Thanks! I've tried that.HOTAIR::MADDOXPoliticians say the darnedest thingsThu Oct 08 1992 17:3410
    Tony,
    
    Thanks!  I have already tried the BIND/SORT.  It takes upwards of five
    minutes to display the first screen of ~250 records out of a file of
    ~10,000 records on a not very loaded 8650.  Is this what I should
    expect, or do I need to look for additional ways to enhance
    performance?  Do you have a guess as to how much this will improve when
    I install 3.0?
    
    Joe
1576.33 seconds versus minutes...SHIRE::CACHRL::IreneIl n'y a pas le feu au lac !Thu Oct 08 1992 18:073
It takes me 3 seconds to get the first 20 records of a 5000 records 
file indexed on 4 keys using an alternate key under Version3.0. That 
takes me minutes under v2.4....
1576.4SIOG::T_REDMONDThoughts of an Idle MindThu Oct 08 1992 18:3610
    .3 proves the point...
    
    I use BIND/SORT against alternate KORs and it seems to be better than
    against other fields... I don't know if the code is clever like this,
    however.
    
    BIND against alternate KORs (in V3.0) is a big step forward when you
    have to deal with large data sets.
    
    T