List Object Limit

[Nathzn]

Hi Guys,

Quick question - tried to find the information through genesys documentation but cannot find this.

Do List Objects have a limit? if it does how big can it go?

Thanks,
Nathan

[Kubig]

My opinion is that the limit is given by used database, but I am not pretty sure about it. But, I cannot imagine reasons for creating so big list with so many key-value pairs and section. We are using ListObject very often and within each installation and the maximum values within one ListObject is approx 5k.

[Nathzn]

Hi Kubig,

Thanks for the response, we plan to use a new list to store customer input/data from our IRD strategies. Which could result in the list becoming very big. What would be your opinion on this?

Thanks

[terry]

There is no any "hardcoded" limitations on list size.
Just URS keep entire list data (plus associated hashtables) in memory so it will depends from how much memory URS might use.

Plus (if such necessity happens) updating huge lists directly from strategies might result URS performnce problems. 

[mduran22]

Have you considered writing this out to a custom database? That way you can set your limits on the database itself and not worry about affecting the config database with writes or reads. That way if someone runs a massive query you won't see performance issues. You can also set a time out value for database calls so that if there is no response DB Server (I believe) closes the connection and responds with an error.

[Fra]

[quote author=Nathzn link=topic=8409.msg36931#msg36931 date=1404311659]
Hi Kubig,

Thanks for the response, we plan to use a new list to store customer input/data from our IRD strategies. Which could result in the list becoming very big. What would be your opinion on this?

Thanks
[/quote]

You can store anything you like in List Objects, however, they weren't designed to store large amount of customer data, but just to provide a flexible mechanism to manage your environment (resource-related, rather then customer related).

Plus, I would object that using them to store (possibly sensible) customer data it's neither really compliant to security regulations nor easily manageable (how would you do look up, mass inserts etc?).

Fra

[Nathzn]

Hi,

Thanks you all for the detailed responses, this will help indefinatly! I think the sensible option is to use a database to store the customer data and keep list objects to manage the enviroment dynamically.

I also have another question - is it possible to script/automate data into a list object? would be interested if anyone has complete/attempted this.

Cheers,

[mduran22]

It is possible to write automate scripts to insert/update data in to the config database using config SDK API. I haven't done it for a list object, but have done it to update/insert RoutePoints, Extensions, VT ports.