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

Re: BOOM!

From	owl <owl@rooftop.invalid>
Newsgroups	comp.os.linux.advocacy
Subject	Re: BOOM!
Date	2017-04-15 19:29 +0000
Organization	O.W.L.
Message-ID	<ahjxv03.agu4@rooftop.invalid> (permalink)
References	(5 earlier) <ocrp18$mnk$2@dont-email.me> <azv003a.ghuru@rooftop.invalid> <ocrst8$oof$2@dont-email.me> <azx8c902.b@rooftop.invalid> <oct8qh$dlg$3@dont-email.me>

Show all headers | View raw

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.  SC allocates
for pointers for every cell in the range bounded by A0 and the outermost
vertex cell.  So the question becomes, if Excel doesn't even allocate
pointers for those cells, do *they* even exist?  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.  A nearly empty file should come in
at under 150 GB even assuming some reserve allocation.

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! 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: 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! 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