emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

* performance of exporting large tables
@ 2013-05-16 20:24 D M German
  2013-05-16 22:59 ` Suvayu Ali
  0 siblings, 1 reply; 6+ messages in thread
From: D M German @ 2013-05-16 20:24 UTC (permalink / raw)
  To: emacs-orgmode


hi everybody,

I have a table with 15 columns and 500 rows. One of the columns is a
URL.

org-mode is hanging while exporting the table. It does not seem to
crash, but it is taking a significant amount of time. The worst part is
that it does not appear to be linear.

80 rows -> 17 seconds
160 rows (same 80 rows duplicated) -> 58 seconds

160 rows, 8 columns -> 21 seconds (it seems to not matter which columns
there are).

I wonder if this is expected behaviour. Given that org does not sort the
tables, why does the time increase non-linearly to the size of the
table?

If interested, I can make the table available.

thanks a lot!

--daniel


--
Daniel M. German                  "And ye shall know the truth,
   John 8:32 ->                    and the truth shall make you free."
http://turingmachine.org/
http://silvernegative.com/
dmg (at) uvic (dot) ca
replace (at) with @ and (dot) with .

 

^ permalink raw reply	[flat|nested] 6+ messages in thread

• * Re: performance of exporting large tables
    2013-05-16 20:24 performance of exporting large tables D M German
  @ 2013-05-16 22:59 ` Suvayu Ali
    2013-05-17 19:51   ` D M German
    0 siblings, 1 reply; 6+ messages in thread
  From: Suvayu Ali @ 2013-05-16 22:59 UTC (permalink / raw)
    To: emacs-orgmode
  
  Hi Daniel,
  
  On Thu, May 16, 2013 at 01:24:10PM -0700, D M German wrote:
  > 
  > If interested, I can make the table available.
  
  A working example that reproduces the issue always helps.  If you could
  post the table (of course after removing sensitive/private information)
  it would be great help for the developers and testers.
  
  Thanks,
  
  -- 
  Suvayu
  
  Open source is the future. It sets us free.
  
  ^ permalink raw reply	[flat|nested] 6+ messages in thread

• • * Re: performance of exporting large tables
      2013-05-16 22:59 ` Suvayu Ali
    @ 2013-05-17 19:51   ` D M German
      2013-05-18  8:41     ` Nicolas Goaziou
      0 siblings, 1 reply; 6+ messages in thread
    From: D M German @ 2013-05-17 19:51 UTC (permalink / raw)
      To: emacs-orgmode
    
    
    Hi Suvayu,
    
     Suvayu> Hi Daniel,
     Suvayu> On Thu, May 16, 2013 at 01:24:10PM -0700, D M German wrote:
     >> 
     >> If interested, I can make the table available.
    
     Suvayu> A working example that reproduces the issue always helps.  If you could
     Suvayu> post the table (of course after removing sensitive/private information)
     Suvayu> it would be great help for the developers and testers.
    
    Here is a trivial example:
    
    http://turingmachine.org/~dmg/temp/bigTable.org
    
    (you can do anything with this file, including adding it to any battery
    of tests in the future).
    
    - Latex works well (export within a couple of seconds)
    - ASCII, HTML, Markdown (based on html so no surpise) take more than a
      minute.... 
    
    Does anybody know where the processing might be taking time? 
    
    thanks again,
    
    --daniel
    
    
     Suvayu> Thanks,
    
     Suvayu> -- 
     Suvayu> Suvayu
    
     Suvayu> Open source is the future. It sets us free.
    
    
    
    --
    Daniel M. German                  "Operating systems are like underwear,
       Bill Joy ->                     nobody really wants to look at them."
    http://turingmachine.org/
    http://silvernegative.com/
    dmg (at) uvic (dot) ca
    replace (at) with @ and (dot) with .
    
     
    
    ^ permalink raw reply	[flat|nested] 6+ messages in thread

  • • * Re: performance of exporting large tables
        2013-05-17 19:51   ` D M German
      @ 2013-05-18  8:41     ` Nicolas Goaziou
        2013-05-18 16:30       ` Nicolas Goaziou
        0 siblings, 1 reply; 6+ messages in thread
      From: Nicolas Goaziou @ 2013-05-18  8:41 UTC (permalink / raw)
        To: dmg; +Cc: emacs-orgmode
      
      Hello,
      
      D M German <dmg@uvic.ca> writes:
      
      > Here is a trivial example:
      >
      > http://turingmachine.org/~dmg/temp/bigTable.org
      >
      > (you can do anything with this file, including adding it to any battery
      > of tests in the future).
      >
      > - Latex works well (export within a couple of seconds)
      > - ASCII, HTML, Markdown (based on html so no surpise) take more than a
      >   minute.... 
      >
      > Does anybody know where the processing might be taking time?
      
      As ELP shows, there are a couple of functions involed. I'm not surprised
      though.
      
      I am going to have a look at this.
      
      Thanks for the example.
      
      
      Regards,
      
      -- 
      Nicolas Goaziou
      
      ^ permalink raw reply	[flat|nested] 6+ messages in thread

    • • * Re: performance of exporting large tables
          2013-05-18  8:41     ` Nicolas Goaziou
        @ 2013-05-18 16:30       ` Nicolas Goaziou
          2013-05-21 21:02         ` D M German
          0 siblings, 1 reply; 6+ messages in thread
        From: Nicolas Goaziou @ 2013-05-18 16:30 UTC (permalink / raw)
          To: dmg; +Cc: emacs-orgmode
        
        Nicolas Goaziou <n.goaziou@gmail.com> writes:
        
        > I am going to have a look at this.
        
        I pushed a commit caching the results of some table functions. Export of
        large tables should be a lot faster (I get 6 s now; it was 90 s before).
        
        
        Regards,
        
        -- 
        Nicolas Goaziou
        
        ^ permalink raw reply	[flat|nested] 6+ messages in thread

      • • * Re: performance of exporting large tables
            2013-05-18 16:30       ` Nicolas Goaziou
          @ 2013-05-21 21:02         ` D M German
            0 siblings, 0 replies; 6+ messages in thread
          From: D M German @ 2013-05-21 21:02 UTC (permalink / raw)
            To: Nicolas Goaziou; +Cc: emacs-orgmode
          
           Nicolas Goaziou twisted the bytes to say:
          
          
           Nicolas> Nicolas Goaziou <n.goaziou@gmail.com> writes:
           >> I am going to have a look at this.
          
           Nicolas> I pushed a commit caching the results of some table functions. Export of
           Nicolas> large tables should be a lot faster (I get 6 s now; it was 90 s before).
          
          Hi Nicolas,
          
          thank you very much. This has resolved my issue. I can now export an org file
          with these tables in few seconds.
          
          thank you,
          
          --daniel
          
          
           Nicolas> Regards,
          
           Nicolas> -- 
           Nicolas> Nicolas Goaziou
          
          
          --
          Daniel M. German                  "To read is to travel without all the hassles of luggage."
                                             Emilio Salgari
          http://turingmachine.org/
          http://silvernegative.com/
          dmg (at) uvic (dot) ca
          replace (at) with @ and (dot) with .
          
           
          
          ^ permalink raw reply	[flat|nested] 6+ messages in thread

end of thread, other threads:[~2013-05-21 21:02 UTC | newest]

Thread overview: 6+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2013-05-16 20:24 performance of exporting large tables D M German
2013-05-16 22:59 ` Suvayu Ali
2013-05-17 19:51   ` D M German
2013-05-18  8:41     ` Nicolas Goaziou
2013-05-18 16:30       ` Nicolas Goaziou
2013-05-21 21:02         ` D M German

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).