[MChammaTX]

Does anyone know the limit size of the internalid filter in a search? I remember it was pretty big but I can’t remember the exact size. I have a large amount of data to crunch and was going to pass an array of internalids to the next search to break it out, just want to know the limit. I would probably pass about 2000 internalids of about 8 characters each in length.
This is a cached copy. Click here to see the original post.

[chanarbon]

Hi MChammaTX ,

On my testing, it may depend as well on the complexity of other criteria and columns that you plan to have on the search. I would rather suggest that you refine that big amount of internal ids to be passed as it may also impact the performance of the search. If you plan to use the search on M/R, better have a refined search then let the parallel logic do its jobs if ever you further distribute the results.

[madhur]

I think the Limit is 1000 Internal IDs in a List Filter.

Regards

Madhur

[Olivier Gagnon NC]

We’ve struggled with this recently. We circulated the question pretty high up the support chain, but NetSuite engineers were unable to provide an answer. It *appears* to be a character count limit more than an actual quantity limit, which makes things interesting. You’re going to have to trial & error it until you find what works. I think we have a process that ends up with about a 14000 character count and that is working. So… give it a shot.

[cblackburn]

The performance implications of this approach are not good. It is better to use a paged search.

[Olivier Gagnon NC]

There are reasons why this approach was necessary. And actually, surprisingly, the performance of the approach is surprisingly decent. I agree in general with the statement of “try to avoid doing it this way”, but if for {reasons} you have to go this way, it can actually work.

[Author]

Posts