If you were to run the query in Oracle SQL, does it take as long?
It might be best to extract the information you require into a text file (or csv file), and read the data from that.
What query language are you using? How complex is your query? And how many records of product details do you have? Are you using keyword test or scripting?
I am using the Oracle SQLs(same as the app under test use) with different levels of complexities based on the web page, ensuring that each query returns only 1 row.
For the approach, I am planning to run a Javascript in the beginning to fetch rows from DB and initialise the data in some persistent variables, then use Keyword test that use this data to fill up the forms and validate the data returned on pages.
Refer to https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/databases/index.html and try to use ADO Components, as it might be faster.
I tried with the ADO components as well, but the underlying queries are taking time, hence I am exploring options.
So kindly help me in setting up a local data storage/cache for my queries.
