Menu

#33 slow down / high memory consumption

open
nobody
None
5
2007-06-14
2007-06-14
Anonymous
No

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!

Discussion

  • Nobody/Anonymous

    shortend source

     
  • Nobody/Anonymous

    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

     
  • Nobody/Anonymous

    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);

     

Log in to post a comment.

MongoDB Logo MongoDB