Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team
Good evening, i would like to know how to test the performance of QVD file while loading data at the dash board.
Say for example
If I am having 100 million records - how many hrs it takes
If i am having 1 GB of data how many hrs it take
if i am having 10 GB of data how many hrs it take.
Is there any object which help us to find or we need to do any thing manually(kindly share if there any statement for it)
Thanks
Srini
Do you know what is the limiting factor for the load, CPU or disk Bandwidth (or IOPS)? You might make a wild guess just extrapolating from what you have from a smaller dataset. In my case it would probably be the disk bandwidth as I have plenty of CPU cores.
It´s hard to infere without knowing your data and your server.
I have some app´s for example that load´s 50 mi of rows (9 gb of data) in only 5 min.
Remember to try to acchieve Optimized Load for all your QVD´s (not applying functions or transformations while loading)