search

informatics-isi-edu / ermrestjs

ERMrest client library in JavaScript
Apache License 2.0
4 stars 3 forks source link

CFDE - Customized count request #951

Closed RFSH closed 2 years ago

RFSH commented 2 years ago

Currently, chaise is using the Reference.getAggregates API to fetch the total count displayed in the recordset pages. This API will internally use the ermrest's aggregate API to fetch the cnt_d of the shortestkey.

While this works in most cases, in a table with millions of rows and complicated facet structure, the generated request might result in a timeout. That's why previously we decided to disable the count in CFDE tables.

We should investigate if there's a special treatment that we can do for CFDE to switch to use a more performant and customized Query for this request.

@karlcz Can you please add more details?

RFSH commented 2 years ago

I'm going to close this issue in favor of #959. This specific feature is not needed anymore.