how to speed up the process of the form to retrieve the records from the database

Hi everybody 

Can anyboby help with this question?

 

I have read an interview question as the following: 

If I have millions of records in a form and to open the form or perform any operation it is taking more time. So how to speed up the process of the form to retrieve the records from the database?

 

Thanks in advance!

  • It has to be investigated. If it is taking more time, then it should have been poorly designed.
    You have to look, if the indexes are properly created on the related tables.
    code issues, Client\server calls etc...
    You may have to use some of the existing performance monitoring tools for investigation. (trace parser).
    technet.microsoft.com/.../jj149695.aspx
Related
Recommended