I have created a browse based on a set. An index was created in the set for the field "status". A filter/query was created "active" that filters the status to active records. There are approximately 15,000 records and the results after an "active" filter are generally about 20. When the filter is run on the browse it takes about 5-6 seconds to filter and you can watch the green status bar in the lower left filter through the records. It is behaving as if the index is not working.
However, when I place the the exact same browse as an embedded browse on a form and run the identical "active" filter, the results appear in just over 1 second. Why would an index work in an embedded browse on a form and not in the stand alone browse? This is being tested on a shadow copy over a network.
You may ask, why not just run the browse in the form? I agree, but that creates a new issue. Once my filter "active" is filtered to the approximate 20 records, I will go to change a field (generally a check box) and once the record is saved it will move that record up to the top of the browse. In other words I want the results list to remain the same when I edit them within the browse. I do not want Alpha to move my recently changed/saved record to the top of the browse in essence hiding all records before it. This behavior does not happen in a stand alone browse, only when it is in a form.
There is perhaps an easy fix or it is a bug. I'm using the latest build of version 9, but this behavior is the same on previous builds and versions.
Travis
However, when I place the the exact same browse as an embedded browse on a form and run the identical "active" filter, the results appear in just over 1 second. Why would an index work in an embedded browse on a form and not in the stand alone browse? This is being tested on a shadow copy over a network.
You may ask, why not just run the browse in the form? I agree, but that creates a new issue. Once my filter "active" is filtered to the approximate 20 records, I will go to change a field (generally a check box) and once the record is saved it will move that record up to the top of the browse. In other words I want the results list to remain the same when I edit them within the browse. I do not want Alpha to move my recently changed/saved record to the top of the browse in essence hiding all records before it. This behavior does not happen in a stand alone browse, only when it is in a form.
There is perhaps an easy fix or it is a bug. I'm using the latest build of version 9, but this behavior is the same on previous builds and versions.
Travis
Comment