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

Re: BOOM!

From	owl <owl@rooftop.invalid>
Newsgroups	comp.os.linux.advocacy
Subject	Re: BOOM!
Date	2017-04-15 23:31 +0000
Organization	O.W.L.
Message-ID	<ahzuv9903.agy83@rooftop.invalid> (permalink)
References	(7 earlier) <ocrst8$oof$2@dont-email.me> <azx8c902.b@rooftop.invalid> <oct8qh$dlg$3@dont-email.me> <ahjxv03.agu4@rooftop.invalid> <ocu7e4$mo9$4@dont-email.me>

Show all headers | View raw

DFS <nospam@dfs.com> wrote:
> On 4/15/2017 3:29 PM, owl wrote:
>> DFS <nospam@dfs.com> wrote:
>>> On 4/14/2017 9:48 PM, owl wrote:
>>>> DFS <nospam@dfs.com> wrote:
>>>>> On 4/14/2017 8:51 PM, owl wrote:
>>>>>> DFS <nospam@dfs.com> wrote:
>>>>>>> On 4/14/2017 8:14 PM, owl wrote:
>>>>>>>> DFS <nospam@dfs.com> wrote:
>>>>>>>>> On 4/14/2017 1:49 PM, owl wrote:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> I may push the column limit up into the millions just for
>>>>>>>>>> the hell of it.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> beat that horse...
>>>>>>>>
>>>>>>>> Poor dead horse Excel 2016 -- pwnage hand-delivered from
>>>>>>>> 1982.
>>>>>>>
>>>>>>>
>>>>>>> If you can't reach the cell, does it exist?
>>>>>>>
>>>>>>
>>>>>> Can you reach cell XFD1048575 (counting from 0) on your Excel
>>>>>> 2016? 17 billion 8-byte pointers.  Go for it.
>>>>>
>>>>>
>>>>> Done Mar 2007 (10 years ago) in Excel 2007.  I was running 1GB or
>>>>> 2GB of RAM then.
>>>>>
>>>>> http://www.angelfire.com/planet/dfs0/XFD1048576.png
>>>>>
>>>>
>>>> How much swap?
>>>
>>>
>>> Whatever the default was.
>>>
>>> There were no speed issues, even with low memory.  Excel and Access have
>>> always been exceedingly fast on Windows.  Apparently the older versions
>>> were written in C and assembler.
>>>
>>> http://www.lextrait.com/vincent/implementations.html
>>>
>>> Access SELECTS and sorts best every db I've ever used.
>>>
>> 
>> Obviously Excel is using a different allocation strategy.  
> 
> Microsoft is smarter than sc.
> 

Microsoft is faking it.

> 
>> SC allocates for pointers for every cell in the range bounded by A0 and the outermost
>> vertex cell.  
> 
> It does that allocation just moving to the cell location?  That seems wonky.
> 
> 

It's called not faking it.  Location in a grid requires that the
grid actually exists.  Otherwise, you end up with something like
what the fakester Excel gives you:  just a cell with a meaningless
name.

> 
>> So the question becomes, if Excel doesn't even allocate
>> pointers for those cells, do *they* even exist?  
> 
> I showed you they exist.
> 

No, you showed text data in one cell that had no reference to
any other cells.

> If I can instantly reach the outermost cell in Excel - or any cell in 
> between - and enter data (as shown) and apply all the same functionality 
> to those cells that I can in the range A1:F10, with no discernable 
> difference in speed, there is no question.
> 

Try summing the range.  Although I wouldn't be surprised if Excel fakes
that too, given how fake it's shown itself to be already.

> 
>> I'm going to dedicate
>> a 1TB usb drive for swap and give it a test run under sc using Excel's
>> approximate row/column limits.  
> 
> Whip that horse until it foams and drops.
> 

Whipped and foaming as it crosses the finish line first.

> 
> 
>> A nearly empty file should come in
>> at under 150 GB even assuming some reserve allocation.
> 
> You're talking about saving a file with a little bit of text or formulas 
> in the first few and the outermost few cell(s), right?  Why would you 
> expect it to be 150GB?  If it is that big, something's way wrong.
>

Not on disk.  On disk it's tiny.

 
> I would try to save such a file with Excel 2007 but I'm running 2003 and 
> MS makes it a hassle to run 2 versions of Office (you can only have one 
> version of Outlook installed at a time).
> 

Why are you running such an old version?  If they clash, get yourself
a VM and run it that way.

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

Thread

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! 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! Snit <usenet@gallopinginsanity.com> - 2017-04-17 08:23 -0700

csiph-web