From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jacob Nielsen Subject: Re: working with tables can be quite painful... Date: Tue, 20 Sep 2016 10:54:48 +0200 Message-ID: <5azin37xyf.fsf@alcensoft.com> References: <87r38jew14.fsf@ucl.ac.uk> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:42558) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bmGpn-0002OS-NO for emacs-orgmode@gnu.org; Tue, 20 Sep 2016 04:55:24 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1bmGpj-0002i1-1L for emacs-orgmode@gnu.org; Tue, 20 Sep 2016 04:55:23 -0400 Received: from [195.159.176.226] (port=44952 helo=blaine.gmane.org) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1bmGpi-0002eA-Qs for emacs-orgmode@gnu.org; Tue, 20 Sep 2016 04:55:18 -0400 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1bmGpa-0005H7-FV for emacs-orgmode@gnu.org; Tue, 20 Sep 2016 10:55:10 +0200 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" To: emacs-orgmode@gnu.org Eric S Fraga writes: Hi, I've had these lines in my org files for a long time. Perhaps they help ? # -*- cache-long-scans: nil; -*- # This makes forward-line much faster and thus org-goto-line # and thus org-table-sum (C-c +) Best regards, Jacob > Hello, > > I am working with a table. It has approximately 130 rows and 20 columns > so it's not huge but also not small. Three columns are text but the > rest are all numbers with some degree of sparsity. Instrumenting org > while working on this table, manipulating the entries in just one row, I > get the following: > > | Function | calls | elapsed time | average time | > |--------------------------+-------+--------------+--------------| > | org-cycle | 20 | 41.550963140 | 2.0775481570 | > | org-table-next-field | 20 | 41.544266727 | 2.0772133363 | > | org-table-align | 5 | 41.470595702 | 8.2941191404 | > | org-mode-flyspell-verify | 52 | 1.0647362189 | 0.0204756965 | > | org-do-latex-and-related | 21 | 0.6656267140 | 0.0316965101 | > | org-element-at-point | 125 | 0.6356939890 | 0.0050855519 | > | org-element--parse-to | 125 | 0.6086256940 | 0.0048690055 | > | org-element--cache-put | 1399 | 0.4963533770 | 0.0003547915 | > > From this, it would seem that the table align function is killing the > performance. 8 seconds per call? On an 8 core Intel(R) Core(TM) > i7-2760QM CPU @ 2.40GHz... so not my wee Pandora where I expect > slowness! > > This is with a not quite up to date org. I'm avoiding upgrading as I am > preparing material for teaching which starts soon and I don't want to > run into issues due to changes in org... so I apologise if things have > changed recently. This performance issue has existed for quite some time > now, however. > > Any suggestions on speeding things up? > > Thanks, > eric