Query one Lakh record

Hello Community,

What is the best way to query one lakh records of data from DB.

please suggest!!!

Thanks

  Discussion posts and replies are publicly visible

Parents
  • Working with any application (irrespective of Appian) if requirement is to query huge records from database below are few suggestions for same:

    1. Make sure you have proper indexing on table. And while trying to make query use this indexes accordingly to make retrieval of data faster

    2. In select query keep only those fields which needs to be displayed

    3. Ask dba to check query execution plan, and make changes at db level to optimize the query plan

Reply
  • Working with any application (irrespective of Appian) if requirement is to query huge records from database below are few suggestions for same:

    1. Make sure you have proper indexing on table. And while trying to make query use this indexes accordingly to make retrieval of data faster

    2. In select query keep only those fields which needs to be displayed

    3. Ask dba to check query execution plan, and make changes at db level to optimize the query plan

Children
No Data