• State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 92 subscribers
  • Views 4343 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

D1IM Webservice - Paging / Limit Resultsize ?

eMiFR
over 8 years ago

The D1IM Webservice has some nice methods like GetListObjectWithDisplays. It also works fine but is very slow when loading thousands of objects. Is there a possibility of limiting the result size - something like paging? For example load at the first call the first 10 objects and on the second call the next 10 and so further on...? How could I accomplish this..

Thanks for any advice!

Parents
  • 0 over 8 years ago

    That function accepts a where clause.  I've not tested this, but I would suspect you could use a WHERE with ROWNUM to limit the results returned.  Of course this assumes the slowness is coming from the marshalling of the data  and not the query itself.

Reply
  • 0 over 8 years ago

    That function accepts a where clause.  I've not tested this, but I would suspect you could use a WHERE with ROWNUM to limit the results returned.  Of course this assumes the slowness is coming from the marshalling of the data  and not the query itself.

Children
No Data