Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th September 2006, 17:54
jcasanov jcasanov is offline
Junior Member
 
Join Date: Oct 2005
Posts: 23
jcasanov is on a distinguished road
Baan: BaaN IV B40c.66 - DB: Informix 9.21 - OS: Windows NT 4
between vs inrange, not in vs ANDed <>
Baan: Baan IVc4
DB: Informix DS 9.21.TC(x)
OS: Windows NT
C/S: None/Unknown

Hi,

i'm working in an enterprise that have Baan IV B40c.66. i'm new here and i'm learning with the old method of "trial and error".

i think i understand (10 months and a million cups of coffee after i started) some of the issues for baan performance (at least those that refer to using indexes, avoid some joins in some cases where is better to do the new select in the selectdo part...

Now my question is because i see in programs a lot of inrange's and (field1 > value_min and field1 < value_max) (for this one i'm prefer between because is more legible) and (field1 <> value and field1 <> value and field1 <> value)... i'm guessing that using between and (in or not in) is not standard in BaaN programs are these constructs low performance? or are there other reasons?

btw, we are using BaaN IV B40c.66 with informix 9.21 TC7 (driver level 1) running at Windows NT

regards,
Jaime Casanova
Reply With Quote
  #2  
Old 6th September 2006, 18:35
lbencic's Avatar
lbencic lbencic is offline
Guru
 
Join Date: Dec 2001
Location: Lisle, IL, USA
Posts: 1,148
lbencic will become famous soon enough
Baan: 2.2d - LN - DB: most - OS: most
The difference with 'between' and 'inrange' comes when you are comparing an index with multiple parts (or other combined fields).

Inrange will compare the range for each field in the combined index individually, and Between will apply the range to the combined field all together.

See the WIKI link for further explanation and examples:

http://www.baanboard.com/programmers...ombined_fields
Reply With Quote
  #3  
Old 7th September 2006, 13:09
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
As you are using Level 1, you have to keep in mind that not all solutions for you mentioned on this board will help you. Therefore: keep on tracing check out the performance on the queries and find the logic why things are going slow. Feel free to use the documents on this SIG and forum to improve your knowledge on this topic.

I know this is a general answer, but in general this problem is very broad. More specific to your question: there is no specific performance reason for using IN RANGE or BETWEEN, it is more a developer decision.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #4  
Old 7th September 2006, 18:45
jcasanov jcasanov is offline
Junior Member
 
Join Date: Oct 2005
Posts: 23
jcasanov is on a distinguished road
Baan: BaaN IV B40c.66 - DB: Informix 9.21 - OS: Windows NT 4
not in

Quote:
Originally Posted by jcasanov
Now my question is because i see in programs a lot of inrange's and (field1 > value_min and field1 < value_max) (for this one i'm prefer between because is more legible) and (field1 <> value and field1 <> value and field1 <> value)... i'm guessing that using between and (in or not in) is not standard in BaaN programs are these constructs low performance? or are there other reasons?
thanks to all who answered me...

but part of my question is still unanswered, what about in and not in... its better to use them or use ORed/ANDed constructions to see if a field does/doesn't contain some list of values?

Thanks in advance,
Jaime Casanova
Reply With Quote
Sponsored Links
  #5  
Old 8th September 2006, 10:03
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
IN/NOT IN vs AND/OR

The usage of an IN/NOT IN should result in the same data approach as an AND/OR. As the writing of an IN/NOT IN is sometimes easier to show the logic of a query, I mostly prefer this one.

So, for performance it should not matter. Maybe there are exceptions, but I don't know them yet.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculcated closing balance <> entered closing balance bbsmanian Finance, Invoicing and Integration 3 8th September 2008 13:28
query.extend.where syntax en@frrom Tools Development 6 3rd May 2005 17:08
Web <> Baan ims_lenor General Discussion & Chat 1 26th November 2003 09:58
Running bx6.1 <> bw6.1 hersly Tools Administration & Installation 0 24th October 2001 18:13


All times are GMT +2. The time now is 17:02.


©2001-2017 - Baanboard.com - Baanforums.com