| 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 |
I have a customer who has written an index form with Name and Telephoneno.
The Telephoneno is the primary key and the Name is the secondary key.
When he is searching on Name it takes long time? My question is - should it
be any difference if you search on Primary or Secondary key (in time) in
an INDEX FORM?
Many thanks for your help
Elisabeth, Office team - Stockholm
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1589.1 | And did they define the RMS file with 2 keys? | A1VAX::BARTH | Shun the frumious Bandersnatch | Fri Oct 09 1992 16:12 | 4 |
If the RMS file doesn't have Name as an alternate key, then ALL-IN-1 must do a sequential lookup. That would certainly make things slower. ~K. | |||||
| 1589.2 | questions | UTRTSC::SMEETS | Martin Smeets DS SSO Utrecht (NL) | Fri Oct 09 1992 17:27 | 16 |
Elisabeth, Two questions: 1. Did the customer create a FDL file for the form ? 2. What was the query statement ? The syntax is formname:alternate_key.fieldname[key] e.g. profil:vmsusr.fulnam["A254950"] A254950 = vms user name Regards, Martin | |||||
| 1589.3 | To expand on .1 | SCOTTC::MARSHALL | Do you feel lucky? | Fri Oct 09 1992 17:28 | 19 |
Was the data file created from an FDL file? If so, does the FDL file specify both the primary and secondary keys? If not, how was the file created, and did the creation method create the required keys? If the file was just created from an ENTRY form with no special action, then it will only have one key. Having got a file with all the required keys, are you explicitly saying you want to use the secondary key when you access the file? That is, if the two fields are PHONE and NAME, are you specifying dataset:NAME to tell ALL-IN-1 you want to do keyed lookups using NAME as the key field? Finally, do the field names in ALL-IN-1 match the RMS key names (ie the key names specified in the FDL file)? Scott | |||||
| 1589.4 | Need V3.0 to fix this | VISUAL::WARFORD | Richard Warford @OPA DTN 393-7495 | Sun Oct 11 1992 17:32 | 15 |
In V2.x of ALL-IN-1 there is a bug in the way secondary keys are
handled with INDEX forms. It will do N IOs to obtain record
N. (So if you have 10 records on the screen) You would see 55 IOs are
needed to display these 10 record if they are the first 10 records
and 555 IOs to display the 100 though 110th records! This tends to
lead to a little bit of a performance problem....
This problem is supposed to be fixed in V3.0 (I haven't tested it
but others indicate they have).
Until you get to V3.0 you may find that overall performance of
a INDEX on secondary key can be better done as a /SORT of the
secondary key field - but accessing the primary key.
Rick
| |||||