[jira] [Commented] (OLINGO-527) Is there any possible ay to reduce build response time of JPA query

["Michael Bolz (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OLINGO-527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14346545#comment-14346545 ] 

Michael Bolz commented on OLINGO-527:
-------------------------------------

Hi [~kjoshi],

in general OData supports filter on expanded entities.
Accordingly Olingo also supports a processor (service) implementation to filter on expanded entities.
But if a service supports it depends on the service implementation (e.g. the Reference Service for the Olingo V2 library supports filter on expanded entities).

Kind regards,
Michael

> Is there any possible ay to reduce build response time of JPA query 
> --------------------------------------------------------------------
>
>                 Key: OLINGO-527
>                 URL: https://issues.apache.org/jira/browse/OLINGO-527
>             Project: Olingo
>          Issue Type: Question
>          Components: odata2-core, odata2-jpa
>            Reporter: Karuna Joshi
>            Assignee: Chandan V.A
>
> We have a very large data base and we are exposing the data using olingo restful web service. when I compare, time taken to execute the same query via jdbc connection and time taken by olingo, there is a significant difference.  Time taken by Olingo is very large.
> Time taken to process JPA query + Time taken to build response is the total time taken by olingo.
> We try to tune the JPA queries using Query hints, but still build response time is also very large.
> I have a question :
> Is there any way we can reduce the time taken to build the response ?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)