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

Re: BOOM!

From	DFS <nospam@dfs.com>
Newsgroups	comp.os.linux.advocacy
Subject	Re: BOOM!
Date	2017-04-15 18:42 -0400
Organization	A noiseless patient Spider
Message-ID	<ocu7e4$mo9$4@dont-email.me> (permalink)
References	(6 earlier) <azv003a.ghuru@rooftop.invalid> <ocrst8$oof$2@dont-email.me> <azx8c902.b@rooftop.invalid> <oct8qh$dlg$3@dont-email.me> <ahjxv03.agu4@rooftop.invalid>

Show all headers | View raw

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.

> 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.

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

I showed you they exist.

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.

> 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.

> 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.

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).

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