Re: Odd text encoding

[Bec C]

I get your point Ken but is power really increasing at such a rate?

On Friday, 11 September 2015, Ken Schaefer  wrote:

> And what would those numbers have looked like 2 years ago? 4 years ago? 10
> years ago?
>
>
>
> Assuming computing power doubles every 18-24 months, then that 5444 years
> will become a lot less, relatively quickly.
>
>
>
> *From:* ozdotnet-boun...@ozdotnet.com
>  [mailto:
> ozdotnet-boun...@ozdotnet.com
> ] *On
> Behalf Of *Greg Keogh
> *Sent:* Friday, 11 September 2015 10:15 AM
> *To:* ozDotNet  >
> *Subject:* Re: Odd text encoding
>
>
>
> but because they were concerned about the possibility of running out of
> bigint values. (Clearly it’s a pity more maths isn’t taught at schools).
>
>
>
> My PC can do a for int loop up to 2^30 in about 20 seconds. To get to 2^63
> non-stop it will take 5444 years -- *GK*
>

Re: Odd text encoding

[罗格雷格博士]

Ah but the issue is how many rows you can write into a table. That's a bit more 
work than a for loop :-)

Regards

Greg

Dr Greg Low
SQL Down Under
+61 419201410
1300SQLSQL (1300775775)

On 11 Sep 2015, at 5:16 pm, Greg Keogh 
> wrote:

Assuming computing power doubles every 18-24 months, then that 5444 years will 
become a lot less, relatively quickly.

I didn't mention that counting to 2^63 is eminently parallelizable, so lets 
divide up a small fraction of the free internet computing power on the problem 
and see how long it takes. I don't have any figures to even begin a rough 
calculation -- GK

Re: Odd text encoding

[Greg Keogh]

>
> Assuming computing power doubles every 18-24 months, then that 5444 years
>> will become a lot less, relatively quickly.
>>
>
I didn't mention that counting to 2^63 is eminently parallelizable, so lets
divide up a small fraction of the free internet computing power on the
problem and see how long it takes. I don't have any figures to even begin a
rough calculation -- *GK*

RE: Odd text encoding

[Ken Schaefer]

Well, there are no guarantees about what we’ll see in the future, but here’s 
some stats for what’s come in the past:
http://pages.experts-exchange.com/processing-power-compared/
e.g. from 1956 through to 2015 has seen a trillion-fold increase in FLOPs. 
Something that would have been a 5000 year problem in 1956 probably would been 
solved a decade ago.

To Greg’s point – storage access speeds have also been increasing pretty 
quickly. I believe Samsung showed off a 16TB 2.5” flash drive recently, with a 
demo of 48 of these in a server, providing 768TB of storage, and 2m IOPS. 
That’s only going to get faster and faster over time.

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On 
Behalf Of Bec C
Sent: Friday, 11 September 2015 4:59 PM
To: ozDotNet 
Subject: Re: Odd text encoding

I get your point Ken but is power really increasing at such a rate?

On Friday, 11 September 2015, Ken Schaefer 
> wrote:
And what would those numbers have looked like 2 years ago? 4 years ago? 10 
years ago?

Assuming computing power doubles every 18-24 months, then that 5444 years will 
become a lot less, relatively quickly.

From: 
ozdotnet-boun...@ozdotnet.com
 
[mailto:ozdotnet-boun...@ozdotnet.com]
 On Behalf Of Greg Keogh
Sent: Friday, 11 September 2015 10:15 AM
To: ozDotNet 
>
Subject: Re: Odd text encoding

but because they were concerned about the possibility of running out of bigint 
values. (Clearly it’s a pity more maths isn’t taught at schools).

My PC can do a for int loop up to 2^30 in about 20 seconds. To get to 2^63 
non-stop it will take 5444 years -- GK