From mboxrd@z Thu Jan 1 00:00:00 1970 From: York Zhao Subject: Re: Extremely slow org-table operations Date: Thu, 30 Oct 2014 10:38:40 -0400 Message-ID: References: <87d29brz2k.fsf@nicolasgoaziou.fr> <54517AE2.8060907@verizon.net> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a113eb8cc2257d40506a4d6ef Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51169) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XkEOC-0006Bq-1I for emacs-orgmode@gnu.org; Fri, 31 Oct 2014 11:46:03 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Xjqs5-0007AX-Oq for emacs-orgmode@gnu.org; Thu, 30 Oct 2014 10:38:46 -0400 Received: from mail-ie0-x236.google.com ([2607:f8b0:4001:c03::236]:56811) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Xjqs5-00079H-Gz for emacs-orgmode@gnu.org; Thu, 30 Oct 2014 10:38:41 -0400 Received: by mail-ie0-f182.google.com with SMTP id rd18so5345807iec.41 for ; Thu, 30 Oct 2014 07:38:40 -0700 (PDT) In-Reply-To: <54517AE2.8060907@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 --001a113eb8cc2257d40506a4d6ef Content-Type: text/plain; charset=UTF-8 @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. York On Wed, Oct 29, 2014 at 7:40 PM, Charles Millar wrote: > 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 > > --001a113eb8cc2257d40506a4d6ef Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
@Charlie Millar:

> IIRC Carsten Dominik made the= following observation: org tables are extremely
> slow if they are u= sed as workbooks/spreadsheets and there are many entries
> (many is u= ndefined).

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. I= t seemed an eternity before the
> addition was completed.

I gu= ess the "entries" here mean the table rows right? Please confirm.=


York


On Wed, Oct 29, 2014 at 7:40 PM, Charles Millar <millarc@ve= rizon.net> wrote:
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 ver= sion 8.2.x.
However, I use the latest org-mode from Git everyday. For example, the vers= ion
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 <mail@nicolasgoaziou.fr> wrote:=
Hello,

York Zhao <gt= dplatform@gmail.com> 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<= br> 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 bu= t
didn't help much. So I decided to report the issue here.
[...]

In summery, the file "te= st.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 th= e
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 be= en 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 extreme= ly slow if they are used as workbooks/spreadsheets and there are many entri= es (many is undefined). He recommended that a spreadsheet program in such s= ituations.

I learned that the hard way when I had one table - four columns, three simp= le addition formulas with about 1,000 entries. It seemed an eternity before= the addition was completed.

Charlie Millar


--001a113eb8cc2257d40506a4d6ef--