3 Replies Latest reply on Jan 21, 2014 8:25 PM by SteveKeiser

    Find speed

    SteveKeiser

      Title

      Find speed

      Post

           I have a database that currently has 1822 records in one of the tables. I have a list layout for that table that is very frequently accessed. I set up several different scripts to access the layout to limit the records and speed up access. It still takes several seconds to access the layout. The scripts perform a find on two fields--one is a number field which shows active records, the other a text field. Both of these fields are indexed. While the several seconds is not much of a problem now, I am wondering if it will be a problem when the database grows significantly. Any thoughts on how to speed up the display of this layout would be appreciated.