#653 Bank statement - create lines - sort dialog

open
nobody
None
3
2007-04-12
2006-09-25
ADAXA
No

using 253d

Bank Statement 'create lines' generated a list of maybe
200 entries. Clicking on the date (or any other) label
to sort the displayed items took about 2 minutes to
respond. The same machine sorting a displayed list of
1000 BP's too about a second.
Why does it take so long?

thanks..

Discussion

  • Jorg Janke
    Jorg Janke
    2006-09-27

    • labels: --> 362041
    • status: open --> pending
     
  • Jorg Janke
    Jorg Janke
    2006-09-27

    Logged In: YES
    user_id=87038

    The query is a bit complex - is that every time ??

     
  • ADAXA
    ADAXA
    2006-09-27

    • status: pending --> open
     
  • ADAXA
    ADAXA
    2006-09-27

    Logged In: YES
    user_id=1039991

    yes, tested multiple times on multiple client machines ..
    same result on a 2ghz machine with a gb of memory.

     
  • Jorg Janke
    Jorg Janke
    2006-10-05

    • status: open --> pending
     
  • Jorg Janke
    Jorg Janke
    2006-10-05

    Logged In: YES
    user_id=87038

    ... this is a (database) server issue, not client. When
    starting the query, how busy is the server? (Sorting is
    on the client - query is on the server)

     
  • ADAXA
    ADAXA
    2006-10-09

    • status: pending --> open
     
  • ADAXA
    ADAXA
    2006-10-09

    Logged In: YES
    user_id=1039991

    A further test when showed that the first time you sort the
    created lines on date it took about 15 secs. if you then
    re-sort on date it is instantaneous. If you then sort on BP
    it takes a further 15 secs and a second sort on BP is
    instantaneous. If you then sort by date it takes a further
    15 secs etc...

    During this time the server showed CPU usage of between 1%
    and 5% with occasional spikes up to 15% or 20% and it is a
    fast machine with 2gb of memory.

    regards

     
  • Jorg Janke
    Jorg Janke
    2006-10-10

    • labels: 362041 -->
    • milestone: 537589 --> 537588
    • priority: 5 --> 3
    • summary: Bank statement - create lines --> Bank statement - create lines - sort dialog
     
  • Jorg Janke
    Jorg Janke
    2006-10-10

    Logged In: YES
    user_id=87038

    *** Reclassified as Bug ***

     
  • Kathy Pink
    Kathy Pink
    2007-04-12

    • milestone: 537588 -->