This website uses cookies for visitor traffic analysis. By using the website, you agree with storing the cookies on your computer.More information

How are Conditions of a RemoteDataBook applied?

General questions regarding the development with JVx.

How are Conditions of a RemoteDataBook applied?

Postby ANH » Wed Aug 22, 2018 9:53 am

Hello,

I have a question about conditions of a RemoteDataBook. Are these conditions always incorporated in the db-query-statement or are they sometimes applied in memory after the fetch?

Thank you!

Best regards,
Andreas
ANH
 
Posts: 11
Joined: Fri Jun 29, 2018 11:42 am

Re: How are Conditions of a RemoteDataBook applied?

Postby Support@SIB » Wed Aug 22, 2018 10:28 am

A condition will be used for the where clause of statements usually, but...

If you use a MemDataBook or a RemoteDataBook with memfilter enabled, the conditions will be used in memory only.

If you have a RemoteDataBook with memfilter enabled, all data will be fetched. Otherwise filtering wouldn't return the right records!
User avatar
Support@SIB
 
Posts: 257
Joined: Mon Sep 28, 2009 1:56 pm

Re: How are Conditions of a RemoteDataBook applied?

Postby ANH » Wed Aug 22, 2018 10:37 am

Thank you for the clarification.

Best regards, Andreas
ANH
 
Posts: 11
Joined: Fri Jun 29, 2018 11:42 am


Return to Development