User Tools

Site Tools


interfaces:gdxxrw_is_slow

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
interfaces:gdxxrw_is_slow [2009/02/16 15:27]
admin created
interfaces:gdxxrw_is_slow [2021/06/03 14:06]
Atharv Bhosekar removed
Line 1: Line 1:
 ====== GDXXRW is slow ====== ====== GDXXRW is slow ======
- +  * Use a parameter file instead of several gdxxrw calls:
-===== Use a parameter file instead of several gdxxrw calls =====+
 <​code>​ <​code>​
 +* this is slow
 $ontext $ontext
 execute '​gdxxrw.exe res.gdx par=TKBF ​  ​rng=stat!b2';​ execute '​gdxxrw.exe res.gdx par=TKBF ​  ​rng=stat!b2';​
Line 15: Line 15:
 execute '​gdxxrw.exe res.gdx par=Ant ​   rng=stat!b20';​ execute '​gdxxrw.exe res.gdx par=Ant ​   rng=stat!b20';​
 $offtext $offtext
 +* this will be faster
 $onecho>​2excel.txt $onecho>​2excel.txt
 par=TKBF ​   rng=stat!b2 par=TKBF ​   rng=stat!b2
Line 29: Line 30:
 execute '​gdxxrw.exe res.gdx @2excel.txt';​ execute '​gdxxrw.exe res.gdx @2excel.txt';​
 </​code>​ </​code>​
-===== Do not share the workbook ​===== +  * Do not share the workbookMicroosft Excel offers a functionality called [[https://support.office.com/en-US/article/use-a-shared-workbook-to-collaborate-49b833c0-873b-48d8-8bf2-c1c59a628534|shared workbook]] which allows several people or even applications editing a shared workbook simultaneously. However enabling that functionality decreases the performance of gdxxrw substantially. Below is an example, which illustrates this:
-Microosft Excel offers a functionality called ​"[[http://office.microsoft.com/en-us/excel/HP052622941033.aspx|shared workbook]]" ​which allows several people or even applications editing a shared workbook simultaneously. However enabling that functionality decreases the performance of gdxxrw substantially. Below is an example, which illustrates this:+
 <​code>​ <​code>​
 $ontext $ontext