Ryan Smith
asked on
Need an equation (Time/minutes) related..please help.
I'm working on a project where I'm running some test to determine how long a system will take to run a data migration tool with specific amounts of data from one system to another. I want to compare the transfer times of using a USB storage device and an eSATA storage device.
The recorded times are as:
USB Device - 2GB of Data - 12mins
USB Device - 5GB of Data - 38mins
USB Device - 20GB of Data - 2Hrs
USB Device - 50GB of Data - Not Recorded
eSATA Device - 2GB of Data - 3mins
eSATA Device - 5GB of Data - 7mins
eSATA Device - 20GB of Data - 21mins
eSATA Device - 50GB of Data - 53mins
What I would like to do is get a formula (using the data captured above) that I can use that I'll be able to "mathematically" calculate how long it will take to migrate X amount of data. YES I can assume how long it will take but I'll need some kind of formula. Please help if possible
The recorded times are as:
USB Device - 2GB of Data - 12mins
USB Device - 5GB of Data - 38mins
USB Device - 20GB of Data - 2Hrs
USB Device - 50GB of Data - Not Recorded
eSATA Device - 2GB of Data - 3mins
eSATA Device - 5GB of Data - 7mins
eSATA Device - 20GB of Data - 21mins
eSATA Device - 50GB of Data - 53mins
What I would like to do is get a formula (using the data captured above) that I can use that I'll be able to "mathematically" calculate how long it will take to migrate X amount of data. YES I can assume how long it will take but I'll need some kind of formula. Please help if possible
It looks like just datasize/minutes and multiply the result by the new datasize.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You need to calculate minutes/datasize and multiply the result by the new datasize, NOT datasize/minutes.
The first thing I would do is look at the average data rate (datasize/minutes)
So take the total for USB data and divide by the total minutes.
Then take your datasize and divide it by that.
Using datasize/minutes is much more standard than minutes/datasize, but as adreaanvw pointed out, RobinD did have it a little backward (typo, I'm sure).
So take the total for USB data and divide by the total minutes.
Then take your datasize and divide it by that.
Using datasize/minutes is much more standard than minutes/datasize, but as adreaanvw pointed out, RobinD did have it a little backward (typo, I'm sure).
ASKER
@adriaanvw... Thanks. Just what i needed. Thank you!!
@adriaanvw
yes, thanks for spotting that.
yes, thanks for spotting that.
Have a look at this Excel sheet...
BitRate.xlsx
BitRate.xlsx
ASKER
I know this question is closed but can you please explain how you got this? You said that
I need to calculate minutes/datasize and multiply the result by the new datasize. What im not understanding is how you got 120/20 and 53/50
I need to calculate minutes/datasize and multiply the result by the new datasize. What im not understanding is how you got 120/20 and 53/50
He just picked the biggest sample from the two datasets.
120 minutes for 20GB on USB
53 minutes for 50GB on eSATA
Personally, I disagree.
Either you should use the 20GB point for both (for fairness) or you should use all the data and get an average.
If you really want to overdo it, you could check for overhead using regression analysis or something, but I doubt you want to do that much.
Also I'd like to reiterate that you should calculate datasize/minutes and then divide by that (instead of minutes/datasize and multiplying). The numbers will be the same, but almost everyone uses size/time (MB/s etc).
120 minutes for 20GB on USB
53 minutes for 50GB on eSATA
Personally, I disagree.
Either you should use the 20GB point for both (for fairness) or you should use all the data and get an average.
If you really want to overdo it, you could check for overhead using regression analysis or something, but I doubt you want to do that much.
Also I'd like to reiterate that you should calculate datasize/minutes and then divide by that (instead of minutes/datasize and multiplying). The numbers will be the same, but almost everyone uses size/time (MB/s etc).
ASKER
Got it.. Thank you.. Wish I can give you some points for that.