Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 36

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Prev Previous Post   Next Post Next
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


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

Jaime Casanova
Reply With Quote

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 18:48.

©2001-2018 - -