https://projects.ecoinformatics.org/ecoinfo/https://projects.ecoinformatics.org/ecoinfo/ecoinfo/favicon.ico?14691340362000-09-22T23:00:00ZEcoinformatics RedmineMetacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4242000-09-22T23:00:00ZMatt Jonesjones@nceas.ucsb.edu
<ul></ul><ul>
<li>Bug 147 has been marked as a duplicate of this bug. ***</li>
</ul> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4252001-07-23T18:16:21ZMatt Jonesjones@nceas.ucsb.edu
<ul></ul><p>Changed milestone for several bugs. Some of these we should consider marking<br />INVALID or WONTFIX.</p> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4262002-02-13T00:03:44ZMatt Jonesjones@nceas.ucsb.edu
<ul></ul><p>Moved issues that we do not intend to address during the current release to the<br />'Postpone' milestone.</p> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4272005-08-11T22:35:18ZSaurabh Gargsgarg@nceas.ucsb.edu
<ul></ul><ul>
<li>Bug 2156 has been marked as a duplicate of this bug. ***</li>
</ul> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4282005-08-11T22:36:38ZSaurabh Gargsgarg@nceas.ucsb.edu
<ul></ul><p>Comment from bug# 2156:</p>
<p>Comparing Metacat with other search engines, there is a major<br />difference in the metacat web interface when compared to others. We<br />dont divide the result into blocks. So any online search will show x<br />number of results at a time. Metacat on the other hand shows all<br />results in one go. I am not sure how to fix this yet but I think we<br />will improve on time in three ways: database processing time, network<br />time and rendering of data in the browser. KNB currently has 1600<br />documents+ and a % search sends back a webpage which is 1.45 MB in<br />size. Hence even if we think of broadband, that is a lot of data being<br />sent back. Same goes for rendering of 1600 documents as compared to<br />10/20 documents. I am not sure though how hard this will be to implement</p> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4292006-09-15T18:24:34ZSaurabh Gargsgarg@nceas.ucsb.edu
<ul></ul><p>The query will probably to be stored on per session basis. Maybe the docids found can be stored in a ordered data structure in the session for each of the clients..</p>
<p>But there has to be a query id also as there might be multiple queries coming in from a client.. hence there might be multiple datasets to store. Hence all the skins and morpho when using paged query returns will have to be modified to include the query id assigned by metacat in there request of next set of results.</p> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4302007-02-26T18:01:18ZMatt Jonesjones@nceas.ucsb.edu
<ul></ul><p>See <a class="external" href="http://www.devx.com/Java/Article/21383/1954?pf=true">http://www.devx.com/Java/Article/21383/1954?pf=true</a> for an excellent discussion of strategies for query paging using JDBC.</p> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4312007-04-03T20:23:09ZChad Berkleyberkley@nceas.ucsb.edu
<ul></ul><p>Metacat now does paged query returns. It also caches the last query with the user's session so that it does not need to re-run the entire query to re-display results. The cache can easily be cleared by running a different query then running the original query if you want to make sure you have the newest results. This works for public and authenticated sessions. I'll leave this bug open for now in case there are any problems that crop up with this solution later.</p> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=4322013-03-27T21:13:24ZRedmine Admin
<ul></ul><p>Original Bugzilla ID was 129</p> Metacat - Bug #129: Metacat Performance: paged Query Returnshttps://projects.ecoinformatics.org/ecoinfo/issues/129?journal_id=207702013-09-10T23:16:32Zben leinfelderleinfelder@nceas.ucsb.edu
<ul><li><strong>Status</strong> changed from <i>In Progress</i> to <i>Closed</i></li></ul><p>Now using SOLR as the search mechanism which absolutely supports paged results.</p>