0

How to save a cell matrix of size 500K x 110 in Matlab in an efficient and quickest way (if possible).

It has a combination of strings and numerical data.

Traditional Matlab "save" method is failing most likely because the matrix is too big.

I tried hdf5write but this does not work when the data types are different within the same matrix data.

I also tried the suggestion here but this method slows over time Cannot save really big matrix in Matlab

I also tried these but over time they slow too http://www.mathworks.co.uk/matlabcentral/fileexchange/24483-fast-function-to-save-a-matrix

Community
  • 1
  • 1
cloudviz
  • 971
  • 4
  • 15
  • 40
  • 1
    `whos` of that matrix? – chappjc Mar 03 '14 at 18:04
  • First of all, don't use cell arrays. – m_power Mar 03 '14 at 19:48
  • Here is the Whos - Size: 831493x108, Byte: 10884056934, Type:cell (This is bigger than the 500K x 110 posted above). – cloudviz Mar 04 '14 at 10:34
  • Have you tried the 7.3 format on the save file? – patrik Mar 04 '14 at 12:53
  • Yes it was given in this link - http://stackoverflow.com/questions/16226803/cannot-save-really-big-matrix-in-matlab. I thought of another solution by writing into CSV (this seems faster than inserting into DB) then a dts package to perform a bulk load into SQL table. – cloudviz Mar 04 '14 at 14:39

0 Answers0