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

2 Replies

Related Content

Performance Testing

DBTable variable from a DBTable

Multiple SOAP requests, increasing one parameter

Using Variables for Numbers that Increase

Get names of DBTables during test execution

Recent Discussions

Floating window bleep overlapping window takes longer time (~10 min) to click the button on it.

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout

testcomplete feature Intelligent Quality Add Ons