Portal loading the whole Choice list takes too long time (20 seconds)

Liuduan · ‎06-07-2022

Hello, All ServiceNow experts,

We have a problem with the choice list. We have a catalog item and it is software. For some software, we may need to order 5000 copies at a time. By default, the maximum number of the same item you can order is 10. In order to order 5000 items at a time. We went to System Definition/ Choice Lists, and increased the choices for table sc_cart_item to 5000. It is working, but the portal page takes 20 seconds to load. The 20 seconds of loading time is too long for a portal page, and it is happening in both our dev and play instances. Apparently, the whole choice list are loaded to the web browser, so it takes long time to load.

Did anyone have the same problem?

We noticed that sn-record-picker takes much shorter time to load. Should we use sn-record-picker instead of choice list?

Thank you for your suggestions.

=---

The HTML code is in the widget: “SC Catalog Item”

HTML file around line 68, and around line 132

Hitoshi Ozawa · ‎06-07-2022

Hi Liuduan,

If it's the same product, can't quantity be set to 5000 on 1 item order instead of placing 5000 item orders?

Liuduan · ‎06-13-2022

It is for software purchase. We are a big university (Texas A&M University), and sometimes we need to order a lot of copies of the same software. A client asked such an option, and it seems to be very reasonable request.

Hitoshi Ozawa · ‎06-13-2022

Hi,

Another thought is to create a new Service Catalog item form be created to enter number of orders. Then create a flow using Flow Designer to create 500 orders.

Nikhil65 · ‎06-13-2022

Hi @Liuduan, I am not sure, how we can decrease the time, but I can help with creating a loading screen for the time when it keeps on loading in background. Do reply, if you want me to assist you in the same or else please ignore. Regards, Nikhil.