JSON API: Field.SelectValues() - Slow Performance

[brunodgarcia]

Hi!

I need to use an external index to do a selection in a QlikSense App.
The query results is a vector of integer values, the key for the table.

I have tried to use the JSON API but the performance was sluggish. It was even slower than using Qlik's full text search.

It took about FOUR MINUTES to select 1.5K values fom the  4.5M table, using an integer column.

Is there any other way to make this work?

Here is the JSON message I have used:

{
"handle": 2,
"method": "SelectValues",
"params": {
"qFieldValues": [
{
"qText": "",
"qIsNumeric": false,
"qNumber": 0
},

{
"qText": "",
"qIsNumeric": false,
"qNumber": 1
}
],
"qToggleMode": false,
"qSoftLock": false
}
}

Thanks!

[Øystein_Kolsrud]

Have you tried this endpoint?

https://help.qlik.com/en-US/sense-developer/April2019/APIs/EngineAPI/services-GenericObject-SelectLi...

My guess is that you will get a better performance using that one. An example of how to use it can be found here:

https://help.qlik.com/en-US/sense-developer/April2019/Subsystems/EngineAPI/Content/Sense_EngineAPI/D...

But you'll have to convert from your list of keys to the position of those keys in the list object which may be tricky depending on how the keys are organized.

[brunodgarcia]

Hi,

The mehod Field.LowLevelSelect() was able to do a 1.5k selection  with reasonable performance.

Is there any way for me to get the indexes of the values of a field?

I still don't get why the selectValues would be so slow when the field is numeric.

Thanks!

[brunodgarcia · Accepted solution]

I got it, LowLevelSelect() = RowNo()-1

Solved!