RE: [viewvc-users] incomplete data from query
David Carson <[email protected]>
| Newsgroups | gmane.comp.version-control.cvs.viewcvs.user |
|---|---|
| Message-ID | <6962071.68566.1256399993155.JavaMail.httpd@localhost> |
I put 1.1.3-dev on a test machine, same results. Now I am trying to look through the code for some clues. I added a debug statement to write out the sql query being formed by the "query rev history" form. What I get is a query that includes a "LIMIT 1000" clause. Is this coming from the row_limit parameter in the config file? I tried increasing it to 10000, but I was surprised to see that the results were still the same. Either the code queries iteratively to gather _all_ the data, or this LIMIT is going to cause invalid results, right? The query is returning one record for each changed path within a given commit (I think), so this 1000 record limit will be exhausted very quickly. What is a reasonable row_limit (if indeed this is what I need to change)? Also, and more importantly, how is the user supposed to know when the limit is exceeded by what the query could have returned? This would at least tell the user that the query was too big and only part of the results were returned. Thanks, David > I upgraded to 1.1.2. No change, still returns only a few recent entries. > > > - version: 1.1.1 > > - repository: SVN 1.6.x (fsfs), with usual trunk/tags/branches setup. > > > > I navigate into .../branches/widget, then click on "query revision history" and ask for all changes since the beginning of time. The result is only a few entries, instead of 50 or more. > > > > If I revise the query to filter on one userid, for example, I can get an entry that did not appear in the first query, even though it should have. > > > > This does not seem to happen for all branches. > > > > I have also gone into the database itself using a db browser. I can see that there are many more entries for the widget path than the results are giving me. > > > > What could be going on? What further information might be helpful in debugging? > > > > Thanks, > > David ------------------------------------------------------ http://viewvc.tigris.org/ds/viewMessage.do?dsForumId=4255&dsMessageId=2411054 To unsubscribe from this discussion, e-mail: [[email protected]].