What's purpose of Stores DBTable? and how to increase the performance if the DBTable have big data

Question

Hi all,I see in the TC have a Stores feature that&nbsp;is stored in TestComplete projects for future comparison and for creating&nbsp;checkpoints. In my project, I use DBTable to store data, but my data is too large and biggest (have more than 400 columns and a thousand records). it very impacts to performance of TC when I open it to developing or modify and running scripts. Anyone has a suggestion or any idea if I want to compare with large data without use DBTable or if use it how to improve performance?&nbsp;Thanks,Vinh

ebarbera · Answer

Hi&nbsp;tuanvinh1008&nbsp;-&nbsp;
&nbsp;
Have you tried running a custom query to only pull out the pertinent information you need to validate? This may help cut down on the amount of data that TestComplete is trying to access and could help with performance.&nbsp;
&nbsp;
The SQL designer can be used for this -&nbsp;https://support.smartbear.com/testcomplete/docs/testing-with/checkpoints/database/sql-designer.html
&nbsp;
Emma

tuanvinh1008 · Answer

Thanks for replying. I will try it.What are the differences between DBTables store and ADO library? when should we use DBTable? when should we use the ADO library?

Forum Discussion

What's purpose of Stores DBTable? and how to increase the performance if the DBTable have big data

Related Content

Using Dynamic SQL in TestComplete DBTable

DBTable variable from a DBTable

Multiple SOAP requests, increasing one parameter

Get names of DBTables during test execution

Increasing variable value

Recent Discussions

Desktop app keyword test, extract alphanum, edit and convert to number for later use?

Chrome browser starts with Sad Face

"SystemError: NULL Object passed to Py_BuildValue" Delay() in Python

Dropdown menu inside of a dropdown menu is not found by testcomplete

Find function with retries