cancel

Lookup Set Limit

SOLVED
Go to solution
Highlighted
Mike Leydon
Super Contributor.

Lookup Set Limit

Hi,

 

Simple question - is there a limitation to the number of items in a lookup set?

 

A client wishes to add over 50,000 item to one!!

 

Before I tell them that they are barking mad (from a practical point of view), does a limit exist?

 

Cheers.

9 REPLIES
EWillsey
Acclaimed Contributor.

Re: Lookup Set Limit

From TRIM_Specs, it says 1024... but also has an asterisk, meaning you could potentially go higher but HP hasn't tested.

50,000 is a massive amount though!
Grundy
Acclaimed Contributor.
Solution

Re: Lookup Set Limit

There's no limit in the sense that TRIM will let you add as many as you want...

However, we've got a site that reached half-million items in a set... they paid HP Professional Services to create a customised tool or add-in to make it work without killing TRIM and everything else around it, so you could potentially buy the same solution.

 

On the other hand, 50,000 is no where near 500,000 and it may work fine.



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
TRIMGuru
Acclaimed Contributor.

Re: Lookup Set Limit

50,000!?!?!?!  I would agree that it's unreal for a lookup set to have that and would seriously question the need for it.  Sounds to me that there's not a lot of "structure" being managed for your records management (I think that you agree that it's too much).

 

You might want to have a "justification meeting" to see if those couldn't be reduced.

 

 

Mike Leydon
Super Contributor.

Re: Lookup Set Limit

Thanks Grundy and others.

 

They want a lookup set that will be a list of property addresses. The first part will be a property ID, which they will always know. The rest of the string will be the actual address. Hopefully it won't be too bad - all they need to do is enter the number and auto-select should pick up the rest of it.

 

After the system goes live, it is intended to integrate TRIM to the application that holds the source information(unless we can can change their minds and do it now).

 

Sounds as though it should work for the time being, if a bit clumsy.

 

Cheers.

Sander Hoogwerf
Outstanding Contributor.

Re: Lookup Set Limit

Given the purpose of the lookup set, you could use locations (specifically the location type Venue).

You can then setup a additional field of type location. In 7.2, you can limit these additional fields to be Venues only.

That way, you'll prevent using that massive lookup set and have "free" searching capability in the locations table without the need for custom development and you have your property information structured in a location object.


(Any opinions expressed in this forum are my own personal opinion and should not be construed as an official statement by DXC Technology.)

Analytics & Data Management
Application & Business Services
DXC Technology
Chris Mcklaren
Outstanding Contributor.

Re: Lookup Set Limit

Another solution would be to create a Record Type to host your 50,000 items and use record relationships.  The performance would be faster.

 

Just a suggestion...

 

Chris Mcklaren

 

Cheers,
Chris Mcklaren
Mike Leydon
Super Contributor.

Re: Lookup Set Limit

Thanks Sander & Chris for the additional suggestions - will see what they think (Sander, they are implementing 7.1.1 - 7.2 came out to late to change at this stage).

 

At the moment we are sticking with the lookup set approach and see how it works.

 

One issue we have though is that TRIMPort won't import the data - it bombs out. Even a smaller one of 4000 entries fails. Don't know where the cutoff is yet, but an import of 10 items works fine :(

 

We will probably write an app to load the data now - either direct to database or via SDK.

 

We have a call logged with HP on this.

 

Regards,

 

Mike.

Grundy
Acclaimed Contributor.

Re: Lookup Set Limit

7.x now has the Bulk Loader API that might be useful for this.

It will import directly into the database.

 

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
Mike Leydon
Super Contributor.

Re: Lookup Set Limit

Hi Grundy,

 

Yep, was thinking of using the Bulk Loader - been using it quite a bit to migrate this customer's existing data from a Lotus Notes based system.

 

HP have confirmed this as a known bug, and it is due for resolution in TRIM 7.3.

 

Mike.