It needs writing in more batch. The memory require to execute that statement is
more than 10x of the theoretical size of lgmat.
lgmat=: ?65536 256$0
bi=: ('Courier New' ; 220) conew 'biffbook'
writenumber__bi 0 0 ; 16384{.lgmat_base_
writenumber__bi 16384 0 ; (16384+i.16384){lgmat_base_
writenumber__bi ((2*16384), 0) ; ((2*16384)+i.16384){lgmat_base_
writenumber__bi ((3*16384), 0) ; ((3*16384)+i.16384){lgmat_base_
save__bi '/tmp/taraLg1.xls'
destroy__bi ''
Devon McCormick wrote:
Is this a problem with having to write the whole file at once?
On 4/21/08, Devon McCormick <[EMAIL PROTECTED]> wrote:
I didn't use a script - I just swiped lines from the "Tara and Excel" lab:
load '~addons/tables/tara/tara.ijs'
lgmat=. ?65536 256$0
bi=: ('Courier New' ; 220) conew 'biffbook'
writenumber__bi 0 0 ; 16384{.lgmat_base_
writenumber__bi 16383 0 ; 16384}.lgmat_base_
|out of memory: writenumber
| stream__l=:stream__l,,(toHeader 515,14),("1)(_2]\toWORD0({:s)#r+i.{.s)
,("1)(_2]\toWORD0,({.s)#,:c+i.{:s),("1)(toWORD0 xf),("1)(_8]\toDouble0,yn)
save__bi 'c:\amisc\taraLg1.xls'
This saved the first half of my large matrix. This is on my 1GB RAM
machine.
On 4/21/08, bill lam <[EMAIL PROTECTED]> wrote:
Devon McCormick wrote:
FWIW - since I have Excel 2007 installed on one of my machines, I
thought
I'd mention that its row and column limits are 1048576 x 16384.
I kept running out of memory trying to use Tara to write my 65536 by
256
matrix of floating point numbers to a spreadsheet. I also had
problems
*/65536 256 8
134217728
This is about 134MB only. Tara should handle it. Can you post your test
script?
I heard that Office 2007 only available in 32-bit. It that true? Could
you confirm this by looking at the task manager?
regards,
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
--
Devon McCormick, CFA
^me^ at acm.
org is my
preferred e-mail
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
