View Single Post
Old 7th September 2006, 13:09
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
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,
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote