From mboxrd@z Thu Jan  1 00:00:00 1970
From: Charles Millar <millarc@verizon.net>
Subject: Re: Extremely slow org-table operations
Date: Fri, 31 Oct 2014 15:12:01 -0400
Message-ID: <5453DF01.90703@verizon.net>
References: <CAD3zm23OLy-7Fds4ED+m3ok5cUCauPS2A8xOaDxC54jxSVgi+A@mail.gmail.com>
	<87d29brz2k.fsf@nicolasgoaziou.fr>
	<CAD3zm20-mupr8pNLm_bFNaAnqQUixrFNRo+xS_+ybNbDj6cOtA@mail.gmail.com>
	<54517AE2.8060907@verizon.net>
	<CAD3zm2253dO-5VVZtwpxuHQQMMd0ocLJNztYgr-sN=g97f4bUw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:55327)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <millarc@verizon.net>) id 1XkHcQ-0000Sr-Bn
	for emacs-orgmode@gnu.org; Fri, 31 Oct 2014 15:12:25 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <millarc@verizon.net>) id 1XkHcI-0006fz-Lx
	for emacs-orgmode@gnu.org; Fri, 31 Oct 2014 15:12:18 -0400
Received: from vms173013pub.verizon.net ([206.46.173.13]:65064)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <millarc@verizon.net>) id 1XkHcI-0006ff-IB
	for emacs-orgmode@gnu.org; Fri, 31 Oct 2014 15:12:10 -0400
Received: from [192.168.1.134] ([70.209.138.107]) by vms173013.mailsrvcs.net
	(Oracle Communications Messaging Server 7.0.5.32.0 64bit (built Jul 16
	2014)) with ESMTPA id <0NEB00CTQPC42P50@vms173013.mailsrvcs.net> for
	emacs-orgmode@gnu.org; Fri, 31 Oct 2014 14:12:06 -0500 (CDT)
In-reply-to: <CAD3zm2253dO-5VVZtwpxuHQQMMd0ocLJNztYgr-sN=g97f4bUw@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: York Zhao <gtdplatform@gmail.com>, emacs-orgmode <emacs-orgmode@gnu.org>

Hi York,

York Zhao wrote:
> @Charlie Millar:
>
> > IIRC Carsten Dominik made the following observation: org tables are 
> extremely
> > slow if they are used as workbooks/spreadsheets and there are many 
> entries
> > (many is undefined).
>
> Thanks for the information, could you please clarify what "entry" 
> means? Does it
> mean org headline, or a row in an org-table?
>
> > I learned that the hard way when I had one table - four columns, 
> three simple
> > addition formulas with about 1,000 entries. It seemed an eternity 
> before the
> > addition was completed.
>
> I guess the "entries" here mean the table rows right? Please confirm.
>
You are correct; I should have said rows. In my file there were 1000 
(+/-) rows and each row had up to three "entries", not including the 
description in the first row.
For instance (without any formulas) in the following row I entered each 
amount in columns 2,3 & 4.

     | this was a transaction | 100.00 | 200.00 | 300.00|

So I considered this three entries. So actually there were 3,000 (+/-) 
entries.

Charlie