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

People

Dates

  • Created:
    2004-11-12 23:13
    Updated:
    2009-07-31 16:09
    Resolved:
    2009-07-31 16:09