MMBase

list.jsp hard on database

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Incomplete
  • Affects Version/s: 1.7.1
  • Fix Version/s: Irrelevant
  • Component/s: Editwizards
  • Description:
    Hide
    original bugid: #6619
    The list.jsp may generate queries that makes system performance go down to zero. The strange thing is that i did not notice this problem in 1.6.5 and 1.7.0
    For example the two editwizards which i had to remove are:
    /mmbase/edit/wizard/jsp/list.jsp
    ?wizard=wizards/articles/articles_news
    &startnodes=calendar_template,event_template (<= two startnodes)
    &nodepath=templates,pages,articles
    &fields=pages.title,articles.title,articles.quotetitle
    &orderby=articles.title
    &directions=up
    &search=yes
    /mmbase/edit/wizard/jsp/list.jsp
    ?wizard=wizards/articles/articles_news
    &startnodes=calendar_template
    &nodepath=templates,pages,articles
    &fields=pages.title,articles.title,articles.quotetitle
    &orderby=articles.title,articles.quotetitle (<= two orderby criteria)
    &directions=up,up
    &search=yes
    Can you please post the database queries which were issued (copy/paste from the query-log).

    Show
    original bugid: #6619 The list.jsp may generate queries that makes system performance go down to zero. The strange thing is that i did not notice this problem in 1.6.5 and 1.7.0 For example the two editwizards which i had to remove are: /mmbase/edit/wizard/jsp/list.jsp ?wizard=wizards/articles/articles_news &startnodes=calendar_template,event_template (<= two startnodes) &nodepath=templates,pages,articles &fields=pages.title,articles.title,articles.quotetitle &orderby=articles.title &directions=up &search=yes /mmbase/edit/wizard/jsp/list.jsp ?wizard=wizards/articles/articles_news &startnodes=calendar_template &nodepath=templates,pages,articles &fields=pages.title,articles.title,articles.quotetitle &orderby=articles.title,articles.quotetitle (<= two orderby criteria) &directions=up,up &search=yes Can you please post the database queries which were issued (copy/paste from the query-log).

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Henk Hangyi added a comment - 2004-11-09 10:37
list.jsp hard on database
The list.jsp may generate queries that makes system performance go down to zero. The strange thing is that i did not notice this problem in 1.6.5 and 1.7.0

For example the two editwizards which i had to remove are:

/mmbase/edit/wizard/jsp/list.jsp
?wizard=wizards/articles/articles_news
&startnodes=calendar_template,event_template (<= two startnodes)
&nodepath=templates,pages,articles
&fields=pages.title,articles.title,articles.quotetitle
&orderby=articles.title
&directions=up
&search=yes


/mmbase/edit/wizard/jsp/list.jsp
?wizard=wizards/articles/articles_news
&startnodes=calendar_template
&nodepath=templates,pages,articles
&fields=pages.title,articles.title,articles.quotetitle
&orderby=articles.title,articles.quotetitle (<= two orderby criteria)
&directions=up,up
&search=yes
Show
Henk Hangyi added a comment - 2004-11-09 10:37 list.jsp hard on database The list.jsp may generate queries that makes system performance go down to zero. The strange thing is that i did not notice this problem in 1.6.5 and 1.7.0 For example the two editwizards which i had to remove are: /mmbase/edit/wizard/jsp/list.jsp ?wizard=wizards/articles/articles_news &startnodes=calendar_template,event_template (<= two startnodes) &nodepath=templates,pages,articles &fields=pages.title,articles.title,articles.quotetitle &orderby=articles.title &directions=up &search=yes /mmbase/edit/wizard/jsp/list.jsp ?wizard=wizards/articles/articles_news &startnodes=calendar_template &nodepath=templates,pages,articles &fields=pages.title,articles.title,articles.quotetitle &orderby=articles.title,articles.quotetitle (<= two orderby criteria) &directions=up,up &search=yes
Andre van der Elst made changes - 2006-11-24 13:46
Field Original Value New Value
Assignee Default Project Leader [ mmbaseleader ] Michiel Meeuwissen [ mihxil ]
Hide
Permalink
Michiel Meeuwissen added a comment - 2007-02-02 20:46
I have no idea.Probably it can be 'wontfix'?
Show
Michiel Meeuwissen added a comment - 2007-02-02 20:46 I have no idea.Probably it can be 'wontfix'?
Michiel Meeuwissen made changes - 2007-02-02 20:46
Fix Version/s 1.9.0 [ 10119 ]
Hide
Permalink
Michiel Meeuwissen added a comment - 2008-07-15 22:56
Can you please verify this, and perhaps obtain a produced SQL statement from the query log or so.
Show
Michiel Meeuwissen added a comment - 2008-07-15 22:56 Can you please verify this, and perhaps obtain a produced SQL statement from the query log or so.
Michiel Meeuwissen made changes - 2008-07-15 22:56
Fix Version/s 1.9.2 [ 10171 ]
Fix Version/s 1.9.0 [ 10119 ]
Assignee Michiel Meeuwissen [ mihxil ] Henk Hangyi [ henk ]
Hide
Permalink
Michiel Meeuwissen added a comment - 2009-07-31 16:09
As long as the exact reason is not known, it cannot be fixed.
Show
Michiel Meeuwissen added a comment - 2009-07-31 16:09 As long as the exact reason is not known, it cannot be fixed.
Michiel Meeuwissen made changes - 2009-07-31 16:09
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s Irrelevant [ 10172 ]
Fix Version/s 1.9.2 [ 10171 ]
Resolution Incomplete [ 4 ]

People

Dates

  • Created:
    2004-11-12 23:13
    Updated:
    2009-07-31 16:09
    Resolved:
    2009-07-31 16:09
Atlassian JIRA (v4.1#519) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for MMBase Foundation. Try JIRA - bug tracking software for your team.