Micro Focus QTP (UFT) Forums

Hi
I have lotz of data to be tested in my application

i hav decided to keep it in external excel to make it user friendly

but i have heared that reading the large number of data from excel has some disadvantages (like it makes the code execution slow)

could any bdy tell me what all kind of disadvantages i can face and what can be the alternatives to the same

I have not used Excel to store huge amount of data, and so I will not be able to give you any pros or cons on that.

One other way is to use a Database (Example: SQL Server Express edition, etc) to store your data, and then read directly from your script during runtime.

thanks for the reply
as per i know the test data for the scripts we can put into DataTables OR keep into excel. while u keep in an external xcel then we can also take the data into array variable and then use inside in the script which might be little faster than reading directly from excel