Re: Speed of odsread

[hjborsje]

PhilipNienhuis wrote
> PhilipNienhuis wrote
>> (Hey I did send a reply though Nabble bit it didn't arrive. Attempt #2)
>> 
>> 
>> hjborsje wrote
>>> I'm comparing the speed of loading a LibreOffice (*.ods) spreadsheet in
>>> Octave and MATLAB.  The results are so vastly different that I wonder if
>>> I'm
>>> doing it correctly.  A spreadsheet with 1900 rows, 23 columns takes 135
>>> seconds in Octave. In Matlab 5.5 seconds.   A larger spreadsheet of
>>> 60,000
>>> x
>>> 23 takes 10.5 seconds in Matlab. Octave did not finish after 10 minutes.  
>>> I
>>> run Octave 4.2.1 with all the latest packages on Windows 10.  I enter:
>>> [s,~,~,~] = odsload ('MySpreadsheet.ods',1);  Adding a third and fourth
>>> parameters makes no significant difference.
>> 
>> What spreadsheet I/O "interface" did you use? and windows 32 or 64 bit?
>> 
>> The "native" spreadsheet I/O interface ("OCT") for .ods is know to be
>> pathetic as regards speed. In addition .ods is an almost equally
>> pathetically complex file format.
>> 
>> The fastest interface for .ods we've got on offer is jOpendocument, but
>> it
>> is Java-based.
>> Until Octave has better functions for morphing heterogeneous Java data
>> structures into Octave cell arrays (maybe, sometime) we cannot beat
>> matlab
>> with its Excel backend.
> 
> FYI, just some benchmarks with the file you uploaded:
> 
> tic; [tic; [~, ~, raw] = odsread ("RData_01b.ods", 1, "", 
> <intf>
> ); toc
> 
> gives when specifying the following interfaces for 
> <intf>
> :
> 
> "otk": ~18 s.
> "jod": ~10 s.
> "oct": ~96 s.
> "uno": ~35 s.     ## Invokes LibreOffice
> ... and ...
> tic; [~, ~, raw] = xlsread ("RData_01b.ods", 1, "", "com"); toc   ##
> Invokes
> Excel
> ==> about 6 s.
> 
> Philip
> 
> 
> 
> 
> --
> Sent from:
> http://octave.1599824.n4.nabble.com/Octave-General-f1599825.html
> 
> _______________________________________________
> Help-octave mailing list

> Help-octave@

> https://lists.gnu.org/mailman/listinfo/help-octave

My Octave installation must not be complete, I get 'Unsupported' for "otk"
and "uno".  Also "com" fails.
I do have LibreOffice 5.4 and Excel installed on my system and MATLAB reads
xls (as well as .ods) without a hitch.
Any ideas what I missed during the Octave installation?  (Win10 home
64-bits)

Henk



--
Sent from: http://octave.1599824.n4.nabble.com/Octave-General-f1599825.html