Forum Discussion

dpurnima's avatar
dpurnima
Occasional Contributor
2 months ago

Testcomplete : Loading DB data before triggering execution of keyword tests

I want to validate my Web page data for e.g. selected product details,  with the data in the database. But the queries being slow, I want to run all the queries in the project in advance before trigg...
  • rraghvani's avatar
    rraghvani
    2 months ago

    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.

dpurnima's avatar
dpurnima
Occasional Contributor

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.

rraghvani's avatar
rraghvani
Champion Level 3
2 months ago

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.