Thursday, August 2, 2012

Time taken by a normal broadband service to download a file in MB/GB - detailed

This is the detailed version of the post "Time taken by a normal broadband service to download a file in MB/GB"


Broadband Speed / Connections
No of Hrs
 Max download with Full speed in Hrs (MB)
 Max download with Full speed in Hrs (GB)
1 Mbps
1 Mbps
1
450
0.4395
1 Mbps
2
900
0.8789
1 Mbps
3
1350
1.3184
1 Mbps
4
1800
1.7578
1 Mbps
5
2250
2.1973
1 Mbps
6
2700
2.6367
1 Mbps
7
3150
3.0762
1 Mbps
8
3600
3.5156
1 Mbps
9
4050
3.9551
1 Mbps
10
4500
4.3945
2 Mbps
2 Mbps
1
900
0.8789
2 Mbps
2
1800
1.7578
2 Mbps
3
2700
2.6367
2 Mbps
4
3600
3.5156
2 Mbps
5
4500
4.3945
2 Mbps
6
5400
5.2734
2 Mbps
7
6300
6.1523
2 Mbps
8
7200
7.0313
2 Mbps
9
8100
7.9102
2 Mbps
10
9000
8.7891
4 Mbps
4 Mbps
1
1800
1.7578
4 Mbps
2
3600
3.5156
4 Mbps
3
5400
5.2734
4 Mbps
4
7200
7.0313
4 Mbps
5
9000
8.7891
4 Mbps
6
10800
10.5469
4 Mbps
7
12600
12.3047
4 Mbps
8
14400
14.0625
4 Mbps
9
16200
15.8203
4 Mbps
10
18000
17.5781
8 Mbps
8 Mbps
1
3600
3.5156
8 Mbps
2
7200
7.0313
8 Mbps
3
10800
10.5469
8 Mbps
4
14400
14.0625
8 Mbps
5
18000
17.5781
8 Mbps
6
21600
21.0938
8 Mbps
7
25200
24.6094
8 Mbps
8
28800
28.1250
8 Mbps
9
32400
31.6406
8 Mbps
10
36000
35.1563
 10 Mbps
10 Mbps
1
4500
4.3945
10 Mbps
2
9000
8.7891
10 Mbps
3
13500
13.1836
10 Mbps
4
18000
17.5781
10 Mbps
5
22500
21.9727
10 Mbps
6
27000
26.3672
10 Mbps
7
31500
30.7617
10 Mbps
8
36000
35.1563
10 Mbps
9
40500
39.5508
10 Mbps
10
45000
43.9453
12 Mbps
12 Mbps
1
5400
5.2734
12 Mbps
2
10800
10.5469
12 Mbps
3
16200
15.8203
12 Mbps
4
21600
21.0938
12 Mbps
5
27000
26.3672
12 Mbps
6
32400
31.6406
12 Mbps
7
37800
36.9141
12 Mbps
8
43200
42.1875
12 Mbps
9
48600
47.4609
12 Mbps
10
54000
52.7344

Time taken by a normal broadband service to download a file in MB/GB

Many of us have questioned as
 “Which broadband plan is better for me?”
“Which plans to choose for internet connection?”
“What should be check before buying an internet / broadband connection?”
“Should I buy an unlimited bandwidth plan or limited bandwidth plan?”
“How to calculate data downloaded by me from internet/broadband connection”
“How much we can download on my Broadband connections per hour”
This post will finally help you to understand broadband concept and help you in buying the best broadband / internet plan for you…
Here I will explain how much data you can download on different Broadband speed.  It all depends on broadband speed you opt for. 
This also helps us in limiting our usage, if we are using Limited bandwidth connections. (Like 5 Mbps till 20 GB then speed limits to 512Kbps or so on)
Please note: Every broadband connections do not provide continuous / fixed speed all period of time of connection, they vary time to time, thus transfer rate (at which data file is downloaded) also varies.
Thus it is not guaranteed that below speed is what I MUST get; it depends on the fluctuations on speed/ transfer rate of internet connection….

Following table will help you to understand which broadband plans will satisfy your needs.
Broadband Speed / Connections
Transfer rate
Max download with Full speed In 1 hour
128 kbps
16 KBps
56.25 MB
256 kbps
32 KBps
112.5 MB
512 kbps
64 KBps
225 MB
784 kbps
98 KBps
344.53125 MB
1 Mbps
128 KBps
450 MB
2 Mbps
256 KBps
900 MB
4 Mbps
512 KBps
1800 MB (1.75GB)
8 Mbps
1024 KBps (1 MBps)
3600  MB (3.51GB)
16 Mbps
2048 KBps (2 MBps)
7200 MB (7.03GB)
32 Mbps
4096 KBps (4 MBps)
14400 MB (14.06 GB)
Thus if you have a broadband connection as 1 Mbps, you will be able to download 450 MB Max to max in one hour.

For detailed chart of Download Per hr Click here 

Tuesday, February 23, 2010

IIS Port numbers?

80 is the default port for HTTP traffic
21 is the default port for FTP for sending and recieving
data.
443 is the defaulr for SSL traffic
port 25 smtp



FTP: 20, 21,
SMTP: 28,
HTTP: 80,
SSL:443,
DNS: 53
POP3:110
SMTP:25
NNTP:119
IMAP:142


SSL port no:

HTTP: 443
SMTP:456
POP3:995
IMAP:993
NNTP:563
LDAP:636

Monday, February 1, 2010

Updating a set of rows in Sql Server : How to use While loop in Sql Server

Declare @PubId int
set @PubId = 1046

Declare @NewsId int
set @NewsId = 7026


Begin Tran T2
WHILE (@NewsId <= 7125)
BEGIN


update MstReports
set ReportCode = 'Ovum' + CONVERT(VARCHAR(10),@PubId)
where NewsId = @NewsId


print @newsid

SET @NewsId = @NewsId + 1
SET @PubId = @PubId + 1
IF @NewsId = 7126
BREAK;
END

rollback

or

commit