AnsweredAssumed Answered

Find speed

Question asked by SteveKeiser on Jan 21, 2014
Latest reply on Jan 21, 2014 by 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.

Outcomes