From mboxrd@z Thu Jan 1 00:00:00 1970 From: Sebastien Vauban Subject: Re: Performance of table computing Date: Tue, 31 Mar 2015 14:58:26 +0200 Message-ID: <86zj6tz5l9.fsf@example.com> References: <86pp7p1mvu.fsf@example.com> <5avbhh2x4w.fsf@alcensoft.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: 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-mXXj517/zsQ@public.gmane.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Jacob Nielsen wrote: > Sebastien Vauban writes: >> >> In one of my Org files, I have 20 small tables. Among them, 11 have >> a line of formula's (TBLFM), mainly for computing a total (sum), so >> that's in essence relatively standard and simple. > > Try this: > # -*- cache-long-scans: nil; -*- > # This makes forward-line much faster and thus org-goto-line and > # thus org-table-sum (C-c +) > > My org file is 9990 lines and I just do weekly summations on small > tables used for invoices. The performance was driving my crazy but > setting cache-long-scans to nil has made me happy again. Euh... It went down (no suspense anymore) from: __Re-applied formulas to all tables (in 33.32 s)___________________________ to: __Re-applied formulas to all tables (in 0.21 s)___________________________ Well, that's an HUGE improvement! I couldn't believe my eyes... I'll let-bind this variable in my above function, so that I don't have to hardcode this anywhere... Thanks a lot! Best regards, Seb -- Sebastien Vauban