Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.os.linux.advocacy > #408873
| From | owl <owl@rooftop.invalid> |
|---|---|
| Newsgroups | comp.os.linux.advocacy |
| Subject | Re: BOOM! |
| Date | 2017-04-17 00:51 +0000 |
| Organization | O.W.L. |
| Message-ID | <azc8002.by@rooftop.invalid> (permalink) |
| References | (11 earlier) <ocu7e4$mo9$4@dont-email.me> <ahzuv9903.agy83@rooftop.invalid> <ocudki$6ni$2@dont-email.me> <azv03aghu34.amj@rooftop.invalid> <od0vnd$7j6$2@dont-email.me> |
DFS <nospam@dfs.com> wrote: > On 4/16/2017 1:25 AM, owl wrote: > > >> Are you going to make a habit of snipping context like that? > > > faking it > faking it > fakester > meaningless > fakes that too > fake it's shown to be > > Cripes. Here's a hankie. > > > >>> That file saves, and opens, in ~2 seconds, and is 101MB. >>> >> >> https://vid.me/yoQo A little slow to open, being 277 megs of ascii, > > > Why so bloated? > Because of the sc native ascii format. An sc file can be simply: let a0 = 1 let a1 = 2 let a2 = @sum(a0:a1) That's it. It makes sc killer for scripting creation of files, but causes the file sizes to be huge. Instead of an integer being stored as 4 bytes, it's an ascii char for each digit. On the other hand, a file similar to the dummy data file we used above (1...256 x 65536) can be initialized with a sc file containing only: fill a0:iv0 1 1 copy a0:a65535 a0:iv0 let iv65536=@sum(a0:iv65535) That only works on my version which extends rows beyond the default 32768, but the following would work for a standard sc to fill similarly a0:zz32766: fill a0:zz0 1 1 copy a0:a32766 a0:zz0 let zz32767=@sum(a0:zz32766) Very tiny file, but opens as the filled spreadsheet. Now, when you save it from there, it goes to the normal format of let a0 = 1 let b0 = 2 let c0 = 3 ... and the saved file is 384 megs, but it's still nice to be able to create it so simply. > My Excel sheet as tab delimited .txt is just 59MB. > > Small but slow: opens in 20 seconds, saves in 8. > > > >> but I couldn't help but notice how it pwns Excel 2003 on range. > > > You can also navigate sc with vim keystrokes. That's a huge win over Excel. > Yep. > And a/scext files are accepted wherever you see these symbols: > > ⚦ ⚨ ⚩ ⚲ ⚪ ⚢ ⚣ ⚥ ⚧ ? ? > I don't know what those are. > > >>> Extrapolating to the 17.18B cells of Excel 2007, the file would be >>> 1024x as large, or 103.4GB. >>> >> >> LOL! Try doing it with a 103.4GB file with 32GB RAM. See how that >> goes. Here's sc at xfd1048575: >> >> http://imgur.com/a/gR99r >> >> You can see that it's burned through most of my 32GB of RAM and >> taking 128GB of swap. Since Excel fakes it for empty cells, > > waaaa!! Here's a whole /box/ of hankies. > > > >> this gives you an indication of what Excel would do with cells filled >> with data, so your isolated text entry in one cell doesn't mean >> anything. > > 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. Because sc is not faking it like the fakester Excel. > > > > >>>> Why are you running such an old version? >>> >>> Habit, and a boatload of 2003 code and apps. >>> >>> >>> >>>> If they clash, get yourself a VM and run it that way. >>> >>> Not worth the time or effort. >>> >> >> I smell a freetard... > > That's your upper lip. > > > > 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. > Here's a participation ribbon - also awarded to those who don't snicker > when they see Stallman in person.
Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar
BOOM! owl <owl@rooftop.invalid> - 2017-04-14 17:07 +0000
Re: BOOM! DFS <nospam@dfs.com> - 2017-04-14 13:33 -0400
Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-14 17:49 +0000
Re: BOOM! fr314159@gmail.com - 2017-04-14 13:00 -0700
Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-14 20:26 +0000
Re: BOOM! DFS <nospam@dfs.com> - 2017-04-15 10:00 -0400
Re: BOOM! DFS <nospam@dfs.com> - 2017-04-14 19:58 -0400
Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-15 00:14 +0000
Re: BOOM! DFS <nospam@dfs.com> - 2017-04-14 20:23 -0400
Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-15 00:51 +0000
Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-14 18:02 -0700
Re: BOOM! DFS <nospam@dfs.com> - 2017-04-14 21:30 -0400
Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-15 01:48 +0000
Re: BOOM! DFS <nospam@dfs.com> - 2017-04-15 10:00 -0400
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! 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
Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-14 17:37 -0700
Re: BOOM! Chris Ahlstrom <OFeem1987@teleworm.us> - 2017-04-15 06:41 -0400
Re: BOOM! Chris Ahlstrom <OFeem1987@teleworm.us> - 2017-04-14 13:34 -0400
Re: BOOM! John McCue <jmccue@jmcnet2.bstnma.east.verizon.net> - 2017-04-15 21:33 +0000
Re: BOOM! chrisv <chrisv@nospam.invalid> - 2017-04-17 07:09 -0500
Re: BOOM! John McCue <jmccue@jmcnet2.bstnma.east.verizon.net> - 2017-04-18 22:46 +0000
Re: BOOM! owl <owl@rooftop.invalid> - 2017-04-18 23:08 +0000
Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-18 16:32 -0700
Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-18 16:30 -0700
Re: BOOM! Snit <usenet@gallopinginsanity.com> - 2017-04-17 08:23 -0700
csiph-web