 |
Oracle
Apprentice
Joined: 29 May 2002
Posts: 121
|
 Posted: Wed Mar 31, 2004 9:37 pm
ismember() vs db()
|
Anyone know if there is any difference in performance between ismember() vs db() functions?
I'm thinking db() would be faster since it is indexed where ismember() does a search from beginning to end to find the result in the stringlist. |
|
|
|
|
LightBulb
MASTER
Joined: 28 Nov 2000
Posts: 4817
Location: USA
|
Posted: Wed Mar 31, 2004 10:56 pm
|
Since they aren't interchangeable, it probably doesn't matter which is faster. The important question is whether your variable is a list or a record.
Oh, the correct comparisons would be %ismember/%iskey and %item/%db. |
|
|
|
|
Oracle
Apprentice
Joined: 29 May 2002
Posts: 121
|
Posted: Thu Apr 01, 2004 1:24 am
|
The variable is a list when using ismember() and it is a record when using db().
I'll look into the %item and %iskey and see how they are different. I have read the instructions in the past but like all kinds with so many different options, I get tired of making changes all the time when I see something different.. |
|
|
|
|
|
|
|
