From mboxrd@z Thu Jan 1 00:00:00 1970 From: York Zhao Subject: Re: Extremely slow org-table operations Date: Sat, 8 Nov 2014 10:25:20 -0500 Message-ID: References: <87d29brz2k.fsf@nicolasgoaziou.fr> <54517AE2.8060907@verizon.net> <5453DF01.90703@verizon.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:48273) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Xn7tE-0004ba-DG for emacs-orgmode@gnu.org; Sat, 08 Nov 2014 10:25:25 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Xn7tD-0007RO-7q for emacs-orgmode@gnu.org; Sat, 08 Nov 2014 10:25:24 -0500 Received: from mail-ig0-x230.google.com ([2607:f8b0:4001:c05::230]:58339) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Xn7tD-0007RG-2X for emacs-orgmode@gnu.org; Sat, 08 Nov 2014 10:25:23 -0500 Received: by mail-ig0-f176.google.com with SMTP id l13so15636758iga.3 for ; Sat, 08 Nov 2014 07:25:21 -0800 (PST) In-Reply-To: <5453DF01.90703@verizon.net> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: Charles Millar Cc: emacs-orgmode >> > 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. OK, now I see. Charlie's problem is actually completed different from this problem. So what Carsten Dominik mentioned doesn't apply. This is because in Charlie's case there are 1000 rows in a table, whereas mine has only two rows. Since my formula only calculates two rows, and calculating the table doesn't involve data input from anywhere else, it really doesn't make sens that it has to be slow. Needlessly to say that `org-mode' is fantastic, but with this issue, I have to say that `org-mode' is unhealthy. Therefore, I really hope this issue gets addressed. Please let me know what I can do to help. Thanks in advance, York On Fri, Oct 31, 2014 at 3:12 PM, Charles Millar wrote: > 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