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
    30 days 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
30 days 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.