[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bricolage-bugs
Subject:    [Bug 1250] New: stories with large numbers of versions bog down
From:       "DO NOT REPLY - use bugs.bricolage.cc" <bugs () bricolage ! cc>
Date:       2006-09-26 8:05:08
Message-ID: bug-1250-190 () http ! bugs ! bricolage ! cc/
[Download RAW message or body]

http://bugs.bricolage.cc/show_bug.cgi?id=1250

           Summary: stories with large numbers of versions bog down
                    searching
           Product: Bricolage
           Version: 1.8.3
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: Database
        AssignedTo: bugs@lists.bricolage.cc
        ReportedBy: lannings@who.int


I'm not absolutely certain, but large version number seems likely the problem.
We have a story that's updated thrice daily,
so its version number was approaching 2000.
I found that doing a search for this particular story
(or part of its URI, more precisely) caused Search to take
much longer in the UI than for other stories,
and it caused `bric_soap story --search ...` to timeout
at the default --timeout time (the problem was noticed when
the cron script that updates the story started failing).

Not sure what the problem would be, presumably something not scaling
right in the database.


-- 
Configure bugmail: http://bugs.bricolage.cc/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
[prev in list] [next in list] [prev in thread] [next in thread]