slow down / high memory consumption
Status: Beta
Brought to you by:
larsbm
i am creating some export files with approximately 5-10 tables with 120rows and 5-20 columns.
the first time i create this file it takes approximately 55seconds (including db-query)
if i then export the same file again the inserting of the cells takes 4 minutes.
i recreate the complete object which accesses aodl, but the memory consumption stays at 90mb after the first and 190mb after the second export.
please help!
shortend source
Logged In: NO
had forgotton that in each step i create several files..
now i have taken the export times for the first run (55sec overall)
for comparison i added the time it takes to create csv-files with the same amount of data:
ods-file1: 00:00:01.0156250
ods-file2: 00:00:06.8593750
ods-file3: 00:00:08.8750000
ods-file4: 00:00:15.1093750
ods-file5: 00:00:20.9218750
csv-file1: 00:00:00.0312500
csv-file2: 00:00:00.7812500
csv-file3: 00:00:00.6250000
csv-file4: 00:00:00.1250000
csv-file5: 00:00:00.0781250
Logged In: NO
same error source as
[ 1736917 ] Spreadsheet Exception: if 2nd table has more rows than 1st
the problem is the static event OnRowChanged in rows.cs
it lists all tables that are created since programm start.
changes to be done(i used csv version(downloaded 12.6.2007 15:33)):
Row.cs:
line60 (remove static): public event RowChanged OnRowChanged;
line154 (add eventhandler) OnRowChanged += new RowChanged(Table.Row_OnRowChanged);
Table.cs:
line365 (change private to public): public void Row_OnRowChanged(int rowNumber, int cellCount)
line145 (remove add-eventhandler): //Row.OnRowChanged+=new AODL.Document.Content.Tables.Row.RowChanged(Row_OnRowChanged);
line165 (remove add-eventhandler): //Row.OnRowChanged+=new AODL.Document.Content.Tables.Row.RowChanged(Row_OnRowChanged);