Large Dataset Query

Question

I am looking for suggestions on the best and fastest way to query data that has about 50,000 rows of data. My use case is data collection for inventory purposes where an operator will use a handheld device and scan and item_id barcode, the application retrieve a description and then they can scan a qty. The reason for the retrieval is to verify a good part number, also to occasionally verify the barcode to the product. The data currently resides in a SQL database. We are on Appian 22.3 Cloud.

Mike Schmitt · Answer

These sound like standard use cases for a!queryEntity() - the only time you'd have issues is if you're trying to retrieve several thousand rows of data all at once, but the use cases you list here don't seem to indicate a need to do that. 
 For instance, querying an item from a 50,000 row DB to match a single scanned bar code, I would not expect to be any sort of difficult thing for a normal query filtering by, for example, a barcode number field.