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 triggering the actual executions. Sort of like a local data storage/cache.

Is there a way we can do it? Is there a better approach to handle this?

  • 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.

  • rraghvani's avatar
    rraghvani
    Champion Level 3

    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?