[Vtigercrm-developers] Picklist with lots of values

Ing. Matus Sopko sopko at its4you.sk
Mon Oct 17 10:45:32 GMT 2022


For 15k+ values, I will create new "Zip codes" Module with relation to 
Orga, Inv, ... modules.

S pozdravom / Best regards / Mit freundlichen Grüßen
Matus
IT-Solutions4You s.r.o.

Dňa 17. 10. 2022 o 12:32 Oleg Antonov napísal(a):
> Why don’t you use text field for zip code?
>
> I heard about integration with google address, maybe it could help.
>
> If you decide to use dropdown for it, you better implement completely 
> new field type with predefined values. Maybe with regular codes update 
> from some source routine.
>
> El El lun, 17 oct 2022 a las 10:49, nilay khatri 
> <nilay.spartan at gmail.com> escribió:
>
>     Hi,
>
>     In one of our setups, the user has added 15k+ values to a
>     picklist, which are the Zip codes.
>
>     This slows the CRM like anything.
>
>     Has anyone come across such scenarios? Any available solutions?
>
>     Based on our initial research this happens because of the select2,
>     and the fact that all picklist values are to be fetched and
>     initiated. This leads to high resource utilization and DOM
>     building gets slow. Imagine having 2 or more zip fields :)
>
>     As a solution we are thinking of changing the behaviour of select2
>     to load values using ajax.
>
>     But then the challenge would be picklist dependency setups, as
>     that would need all the mapping to be available anyways. So the
>     load times and resource utilization is not going to have any major
>     impact?
>
>     Happy to collaborate.
>     _______________________________________________
>     http://www.vtiger.com/
>
> -- 
> --
> С уважением, руководитель веб-студии PIN
> Антонов Олег.
> +7-921-922-91-91
>
> http://pinstudio.ru
> - Создание и продвижение сайтов
> - Автоматизация бизнеса
> - Увеличение продаж
>
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20221017/714c4311/attachment-0001.html>


More information about the vtigercrm-developers mailing list