cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Best practices on DataTable Query Services

Sathishkumar_C
16-Pearl

Best practices on DataTable Query Services

We are having a following services to get/search/query the data table data. Which service is more efficient?

 

  1. GetDataTableEntries
  2. SearchDataTableEntries
  3. QueryDataTableEntries

 

1 REPLY 1
kazunari
5-Regular Member
(To:Sathishkumar_C)

Hi, here is my understanding.

 

GetDataTableEntries : Just retrieve rows based on maxItems which you set on input. It should be the fastest because no query or expression are defined.

SearchDataTableEntries : You can set a searchExpression and this parameter will work on partial match search against Key columns. This should be the second fastest.

QueryDataTableEntries : This service can set a query and a maxItems in input parameters. Query will work after retrieving the rows so it should be slow than the others when query is defined.

 

However, I cannot decide which is more efficient because it depends on your use case.

I hope this helps you.

Announcements