Forum Discussion

dpurnima's avatar
dpurnima
Occasional Contributor
1 year ago
Solved

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
    1 year 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
1 year ago

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
    Icon for Champion Level 3 rankChampion Level 3
    1 year 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.