Use of " sysparm_query_category " in table API

[lucky6]

What is the use of " sysparm_query_category" in table API.

[Willem]

it is similar to "sysparm_read_replica_category".

The category value to read data from read replicas.
Note: This parameter is not commonly used. The instance needs to have read replica support.

Below is from: https://sn.jace.pro/docs/scripting/gliderecord/

getCategory

The setCategory and getCategory methods are available in GlideRecord for working with query categories when routing to secondary database pools, known as read replicas.

A read replica is a 100% copy of an instance’s database (DB) that can be only queried against with the goal to reduce load on the primary database. It’s a paid feature and requires an extra plugin that can only be activated by ServiceNow. With setCategory you can route some categories to the read replica, so queries for them will not go to primary database anymore (effectively reducing load on primary database).

Source

[Joel Donaldson]

Willem, how can I very if a customer has this plugin activated?

[Tyler Teter]

Information is really sparse, but I believe the related plugin is "com.glide.secondary_db_pools". You can check via sys_plugins if it is installed.