<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div>Hi,</div><div>I want to script a code that reads data from txt or csv files and does some</div><div>calculations on them. In the future I might evaluate large data files,</div><div>run calculation extensive parameter optimizations, do some loops with a high number of onedimensional calculations.</div><div>Therefore I worry about speed and memory usage.</div><div>I run WinXp with 3GB RAM, Intel Core 2Duo. <br></div><div><br></div><div>Since scilab processes all data as variant, how much memory is required for each constant or variable, being string, integer or double?</div><div>I still wonder if I should script via Excel VBA or scilab.</div><div>I will store my results in Excel anyway and it might be therefore easier to use VBA.</div><div>As I have read, scilab can use up to 2 GB RAM,
VBA only 500MB.</div><div>But, in VBA data types can be declared, saving some memory. <br></div><div>Scilab can do multithreading, but not on Windows, which is what I use.</div><div>VBA can't do it eighter.</div><div>VBA might have a larger user community and knowledge Base, Scilab might be easier to script. <br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">I would like to start out with eighter scilab or VBA and then to stick to one of them due to the large amount of code</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;
background-color: transparent; font-style: normal;">and subscripts to write . <br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">So-what is your suggestions?</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;">Thanks very much in advance for your help!<br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br></div></div></body></html>