[ 
https://issues.apache.org/jira/browse/OODT-68?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12969221#action_12969221
 ] 

Chris A. Mattmann commented on OODT-68:
---------------------------------------

bq. let's say i leave setTotalPages(int) as is and just add 
setNumberOfHits(int) and getNumberOfHits() . . . are we cool then?

Possibly, I'd need to see the approach taken in the patch.

bq. and actually . . . in order to get first page of a product type set and 
number of products in that product type it currently causes 5 queries instead 
of just one . . . getFirstPage(ProductType) requires two (one to get num of 
hits and another to get products) . . . 

Umm, let's be clear where these "queries" are occuring. Both the above 2 are 
happening on the fm server end, close to the catalog implementation. So, they 
aren't super expensive.

bq. getLastProductPage(ProductType) calls getFirstPage() and then gets products 
for last page . . . if a query takes 20-30 seconds (typical for large data 
sets) 

Umm, by whose count is this _typical_? It sounds like an indexing issue to me 
with the underlying database implementation. If a query is taking 20-30 seconds 
to do a simple count then there's likely some _other_ issue here. 

bq. that is then 5x30 which is a LONG time for a user to wait for a GUI to load

Agreed, but look at the bounds. 30 by itself is a *long* time to wait for the 
GUi to load by itself? My feeling is that we could always create an alternative 
DataSourceCatalog that implemented paging a different way if we had to deal 
with these performance issues. I'd rather do this than change the *default 
paging implementation* that's part of the actual architecture that's been 
around since the fm inception. And yes, changing/adding/removing a field *is* 
changing the architecture in some way.


> Add Number of Product Hits to ProductPage
> -----------------------------------------
>
>                 Key: OODT-68
>                 URL: https://issues.apache.org/jira/browse/OODT-68
>             Project: OODT
>          Issue Type: Improvement
>          Components: file manager
>    Affects Versions: 0.1-incubating
>         Environment: none
>            Reporter: Brian Foster
>            Assignee: Brian Foster
>            Priority: Minor
>             Fix For: 0.2
>
>
> - By adding get number of hits the method setTotalPages(int) is no longer 
> needed; getTotalPages will calculate its return value based on page size and 
> total hits
> - This also allows the number of products to be determined by just getting 
> the first page, instead of getting last page which internally requires 
> DataSourceCatalog to get first page and last page

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to