From mboxrd@z Thu Jan 1 00:00:00 1970 From: Charles Millar Subject: Re: Extremely slow org-table operations Date: Wed, 29 Oct 2014 19:40:18 -0400 Message-ID: <54517AE2.8060907@verizon.net> References: <87d29brz2k.fsf@nicolasgoaziou.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:34566) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XjcrK-0007BX-Sh for emacs-orgmode@gnu.org; Wed, 29 Oct 2014 19:41:07 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XjcrF-0002Hi-DN for emacs-orgmode@gnu.org; Wed, 29 Oct 2014 19:40:58 -0400 Received: from vms173007pub.verizon.net ([206.46.173.7]:33218) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XjcrF-0002HY-9C for emacs-orgmode@gnu.org; Wed, 29 Oct 2014 19:40:53 -0400 Received: from [192.168.1.6] ([74.111.54.150]) by vms173007.mailsrvcs.net (Oracle Communications Messaging Server 7.0.5.32.0 64bit (built Jul 16 2014)) with ESMTPA id <0NE800B5JCF87U90@vms173007.mailsrvcs.net> for emacs-orgmode@gnu.org; Wed, 29 Oct 2014 18:40:45 -0500 (CDT) In-reply-to: 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: emacs-orgmode@gnu.org Hi, York Zhao wrote: >> I think Org 8.3 should improve the situation. Please test it if you can. > I was aware that my "emacs -Q" test was done against org-mode version 8.2.x. > However, I use the latest org-mode from Git everyday. For example, the version > I'm currently using is (from M-x org-version): "Org-mode version 8.3beta > (release_8.3beta-509-g86ec0a.dirty @ /usr/local/share/emacs/site-lisp/org/)". So > apparently the problem had never been addressed. > >> Meanwhile, I suggest to insert some subsections in your file. > What do you mean by "insert some subsections"? > > > Thanks > > > On Wed, Oct 29, 2014 at 5:43 AM, Nicolas Goaziou wrote: >> Hello, >> >> York Zhao writes: >> >>> A few months ago I tried Emacs 24.4 and was disappointed because almost all of >>> the org-table operations became AT LEAST ten times slower. Because recently >>> Emacs 24.4 gets officially released, I finally switched over. However, the >>> problems I had several months ago were still there, i.e., in a big file, >>> org-table operations are at least ten times slower. I tried profiling it but >>> didn't help much. So I decided to report the issue here. >> [...] >> >>> In summery, the file "test.org" has more than 5000 org-table tables, each table >>> has a formula. If you move the point to the tables not too far away from the >>> beginning of the buffer and press "C-c C-c" on the formula line, you will notice >>> that the speed is very fast which is great. However, if you move the point far >>> away enough from the beginning of the buffer (move to the end for example), you >>> will find that "C-c C-c" on the formula line becomes much slower. >>> >>> Many other operations are also very slow. However, because I haven't been able >>> to create the ECMs for those operations yet, lets focus on this one >>> first. >> I think Org 8.3 should improve the situation. Please test it if you can. >> Meanwhile, I suggest to insert some subsections in your file. >> >> >> Regards, >> >> -- >> Nicolas Goaziou > 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). He recommended that a spreadsheet program in such situations. 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. Charlie Millar