Groups > comp.os.linux.advocacy > #409018

Re: BOOM!

From	owl <owl@rooftop.invalid>
Newsgroups	comp.os.linux.advocacy
Subject	Re: BOOM!
Date	2017-04-17 17:49 +0000
Organization	O.W.L.
Message-ID	<ufd903ga.au@rooftop.invalid> (permalink)
References	(11 earlier) <azv03aghu34.amj@rooftop.invalid> <od0vnd$7j6$2@dont-email.me> <azc8002.by@rooftop.invalid> <od2rpl$8vj$2@dont-email.me> <ac99ba.bfo44@rooftop.invalid>

Show all headers | View raw

owl <owl@rooftop.invalid> wrote:
> DFS <nospam@dfs.com> wrote:
>> On 4/16/2017 8:51 PM, owl wrote:
>> 
>> 
>> 
>>> and the saved file is 384 megs, but it's still nice to be able to
>>> create it so simply.
>> 
>> 
>> 384 megs to store 23M values?
>> 
>> Sum Ting Wong with sc.
>> 
>> 
> 
> Nope.
> 
>> 
>> 
>>>> And a/scext files are accepted wherever you see these symbols:
>>>>
>>>> ⚦ ⚨ ⚩ ⚲ ⚪ ⚢ ⚣ ⚥ ⚧ ? ? 
>>>>
>>> 
>>> I don't know what those are.
>> 
>> 
>> They all mean 'Born an sc user'.
>> 
>> 
>> 
>> 
>>>> http://imgur.com/a/gR99r
>>>>
>>>> I don't see any cells filled with data.
>>>>
>>>> Tell me sc doesn't chew through 160GB just moving to XFD1048575?
>>>>
>>> 
>>> Yes it does.  
>> 
>> 
>> That is majorly /fucked up/.
>> 
>> There's a new holder of the dubious record of "The Shittiest Code on 
>> Earth".  It was LibreOffice (Calc and Base components), but sc wins by a 
>> landslide.  And what do you know - it already has the correct initials.
>> 
>> 
> 
> You mean the fakester Excel.
> 
>> 
>>> Because sc is not faking it like the fakester Excel.
>> 
>> hankie time!
>> 
>> 
>> 
>>>> Note: while being as useless as your old-man-junk, your
>>>> testing-the-limits-of-sc hack does at least appear to be original.
>>>>
>>>> That's the GuhNoo spirit.
>>> 
>>> SC is public domain.
>> 
>> 
>> SQLite is public domain, too, and it has actual users.  Lots of them.
>> 
>> Partially because, unlike sc, it will handle large datasets without 
>> blowing out your memory and disk.
>> 
>> $ python scblows.py 100000 2000
>> scblows.sqlite (no tables) is 0 bytes on disk
>> scblows.sqlite (one empty table 2000 cols) is 61440 bytes on disk
>> added data points: 100,000 rows x 2000 columns = 200,000,000
>> Filled scblows.sqlite is 615,486,464 bytes on disk
>> 
>> Last Data
>> PK    1995  1996  1997  1998  1999
>> ----------------------------------
>> (99991, 1995, 1996, 1997, 1998, 1999)
>> (99992, 1995, 1996, 1997, 1998, 1999)
>> (99993, 1995, 1996, 1997, 1998, 1999)
>> (99994, 1995, 1996, 1997, 1998, 1999)
>> (99995, 1995, 1996, 1997, 1998, 1999)
>> (99996, 1995, 1996, 1997, 1998, 1999)
>> (99997, 1995, 1996, 1997, 1998, 1999)
>> (99998, 1995, 1996, 1997, 1998, 1999)
>> (99999, 1995, 1996, 1997, 1998, 1999)
>> (100000, 1995, 1996, 1997, 1998, 1999)
>> 
>> 24 seconds
> 
> Less than 23 seconds with sc.
> 
> anon@lowtide:~/sc-7.16$ cat data.sc
> fill a0:bxw0 1 1
> copy a1:a99999 a0:bxw0
> 
> anon@lowtide:~/sc-7.16$ 
> 
> anon@lowtide:~/sc-7.16$ time ./sc -Wbxs99991:bxw99999 data.sc 2>/dev/null
>    1995.00   1996.00   1997.00   1998.00   1999.00
>    1995.00   1996.00   1997.00   1998.00   1999.00
>    1995.00   1996.00   1997.00   1998.00   1999.00
>    1995.00   1996.00   1997.00   1998.00   1999.00
>    1995.00   1996.00   1997.00   1998.00   1999.00
>    1995.00   1996.00   1997.00   1998.00   1999.00
>    1995.00   1996.00   1997.00   1998.00   1999.00
>    1995.00   1996.00   1997.00   1998.00   1999.00
>    1995.00   1996.00   1997.00   1998.00   1999.00
> 
> real    0m22.772s
> user    0m17.672s
> sys     0m5.092s
> anon@lowtide:~/sc-7.16$ 
> 
> And here's what it looks like inside sc:
> http://imgur.com/a/jMOF
> 

That should be 
http://imgur.com/a/jMOFY

Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-15 19:29 +0000
  Re: BOOM! Chris Ahlstrom <OFeem1987@teleworm.us> - 2017-04-15 16:24 -0400
    Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-15 21:10 +0000
  Re: BOOM! DFS <nospam@dfs.com> - 2017-04-15 18:42 -0400
    Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-15 23:31 +0000
      Re: BOOM! DFS <nospam@dfs.com> - 2017-04-15 20:29 -0400
        Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-16 05:25 +0000
          Re: BOOM! DFS <nospam@dfs.com> - 2017-04-16 19:49 -0400
            Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-17 00:51 +0000
              Re: BOOM! DFS <nospam@dfs.com> - 2017-04-17 12:54 -0400
                Re: BOOM! Steve Carroll <fretwizzer@gmail.com> - 2017-04-17 10:06 -0700
                Re: BOOM! DFS <nospam@dfs.com> - 2017-04-17 19:28 -0400
                Re: BOOM! Steve Carroll <fretwizzer@gmail.com> - 2017-04-17 17:21 -0700
                Re: BOOM! DFS <nospam@dfs.com> - 2017-04-19 09:41 -0400
                Re: BOOM! fr314159@gmail.com - 2017-04-19 07:48 -0700
                Re: BOOM! Steve Carroll <fretwizzer@gmail.com> - 2017-04-19 08:37 -0700
                Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-17 10:26 -0700
                Ping DFS! - Re: BOOM! Steve Carroll <fretwizzer@gmail.com> - 2017-04-17 10:34 -0700
                Re: Ping DFS! - Re: BOOM! DFS <nospam@dfs.com> - 2017-04-17 19:25 -0400
                Re: Ping DFS! - Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-17 16:45 -0700
                Re: Ping DFS! - Re: BOOM! Steve Carroll <fretwizzer@gmail.com> - 2017-04-17 17:29 -0700
                Re: Ping DFS! - ReBOOM! Fakey's Puppy Whistle Holder Emeritus 🐶笛 <root@127.0.0.1> - 2017-04-17 19:58 -0500
                Re: Ping DFS! - ReBOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-17 18:12 -0700
                Re: Ping DFS! - ReBOOM! Fakey's Puppy Whistle Holder Emeritus 🐶笛 <root@127.0.0.1> - 2017-04-17 20:25 -0500
                Re: Ping DFS! - ReBOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-17 18:46 -0700
                Re: Ping DFS! - ReBOOM! Fakey's Puppy Whistle Holder Emeritus 🐶笛 <root@127.0.0.1> - 2017-04-17 21:20 -0500
                Re: Ping DFS! - ReBOOM! Steve Carroll <fretwizzer@gmail.com> - 2017-04-17 19:00 -0700
                Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-17 17:29 +0000
                Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-17 10:34 -0700
                Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-17 17:49 +0000
                Re: BOOM! DFS <nospam@dfs.com> - 2017-04-17 19:25 -0400
                Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-18 00:06 +0000
                Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-17 17:28 -0700
                Re: BOOM! DFS <nospam@dfs.com> - 2017-04-18 12:00 -0400
                Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-18 09:28 -0700
                Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-18 20:11 +0000
                Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-18 13:13 -0700

csiph-web