Hi

How can I achieve the following query (paging inside the subquery)? Pseudo code:

select * 
from A
where id in
  (
  select id
  from A
  where .....
  order by id asc,
  limit 100
  offset 1000
  )

I need to optimize the paging query. The query analizer shows me +- 5x optimization in my case when I do a paging in a subquery.

Best regards, MiloszeS

You should use a FieldCompareSetPredicate in your filter. There is some FieldCompareSetPredicate ctor that accepts a maxItemsToReturn parameter.

Yes, I've already found the parameter for the limit clause (maxNumberOfItemsToReturn), but I also need the offset parameter.

Best Regards, MiloszeS

Limit and Offset are you used for paging as you have said.

I can't think of a scenario where paging in a sense is used for filtering. Could you please provide a scenario where this might be needed?

Our framework doesn't allow paging inside subqueries as most databases require extra constructs to perform paging which aren't allowed inside a subquery, plus the use case for paging inside a subquery is unclear...

Could you give the full query you're trying to produce? The query you gave has a select * from wrapper around the real query which is meaningless (it doesn't do anything other than return the inner query's result).