Maximum Data-Binding possible with Excel

Ask general questions here.
rafath
Posts: 2
Joined: Wed Oct 24, 2018 9:11 am

Maximum Data-Binding possible with Excel

Post by rafath » Wed Oct 24, 2018 9:16 am

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

User avatar
N612
Posts: 62
Joined: Mon Jul 11, 2016 4:01 pm

Re: Maximum Data-Binding possible with Excel

Post by N612 » Wed Oct 24, 2018 6:56 pm

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.

rafath
Posts: 2
Joined: Wed Oct 24, 2018 9:11 am

Re: Maximum Data-Binding possible with Excel

Post by rafath » Thu Oct 25, 2018 5:18 am

Hi,

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

Regards,
Rafath B

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 3908
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: Maximum Data-Binding possible with Excel

Post by odklizec » Thu Oct 25, 2018 8:34 am

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 ;)
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration