Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Lookup table performance row count limitation

edited May 24, 2019 5:26AM in Integration 1 comment

Summary

Is there a row count limitation for lookup tables

Content

Hi

We need to support lookup tables with 7,000 rows. I would like to use OIC's lookup tables obviously but in a performance test  we ran on the lookup function we received inconsistent results. Sometimes 500 ms, some times 2 sec and sometimes much more.

I'm wondering if we're hitting some limitation and more importantly if there's a way to tune it. Will log a SR tomorrow but thought maybe someone in the community knows.

Thanks
Ronen

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!