I'm seeing hugely different search times when swapping out a parameter in a saved search. If I call

nlapiLoadSearch()

and add a

department

filter, the search returns over 1000 results and I can

resultSet.getResults(0,1000)

in about 9 seconds. If I call

nlapiLoadSearch()

and add a

custom_column, department

(

department

join on

custom_column

) filter, the search returns over 1000 results, but

resultSet.getResults(0,1000)

takes over 60 seconds. Is this because of the join on the second search? Heading out the door, but I'll check this later.