Page 1 of 1

Maximum Data-Binding possible with Excel

Posted: Wed Oct 24, 2018 9:16 am
by rafath
Hi,

Maximum how many data bindings are possible right now.
I'm having a test suite in which I am expecting around 1000(thousand) data binding to be made using excel, as all my test cases will be independent and I don't want to delete the test case which I have already run.

Regards,
Rafath B

Re: Maximum Data-Binding possible with Excel

Posted: Wed Oct 24, 2018 6:56 pm
by N612
There is no limit, but it is possible you could run into I/O performance issues with that many data connectors. Since all of the test cases are independent, perhaps you can utilize multiple test suites (introduced in Ranorex 8.2.0) to avoid this potential issue.

Re: Maximum Data-Binding possible with Excel

Posted: Thu Oct 25, 2018 5:18 am
by rafath
Hi,

How many data bindings will be recommended per solution without any performance issue.

Regards,
Rafath B

Re: Maximum Data-Binding possible with Excel

Posted: Thu Oct 25, 2018 8:34 am
by odklizec
Hi,

There is no definitive answer for this. It really depends on the structure of your tests and structure and size of excel files. The worst issue I've experienced, while using Excel data connectors in a medium-sized project, was a noticeable slowdown, during an attempt to open the Excel data connector. It takes several second to simply open the data connector dialog. In the same project, where I started to use CSV data connectors, the CSV data connectors open instantly. So I dropped Excel from all new projects and use exclusively CSV. Aside the speed difference, CSV files can be edited directly in Ranorex data connector dialog and there is no problem with comparison of CSV files while checkin then to vcs. The only downside of CSV files is, that they don't have tabs ;)