Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: BOOM!

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

Show all headers | View raw

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

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