1 Nickel

Limiting query results

I was trying to fetch the xsets from storage and following XAM QL is used

"SELECT \".xset.xuid\" WHERE \".xset.time.xuid\" > date('"+sdf.format( "+somedate+")+"')"

This query takes a lot of time than  SELECT \".xset.xuid\"

Most of the time the count of results is populated only after the job is completed

Is it possible to fetch the data from centera in a paginated manner?

0 Kudos
1 Reply
8 Krypton

Re: Limiting query results

XAM Query on Centera is really a disaster recovery tool and, "database like" performance is not possible. Due to the nature of your query, the performance you are getting is to be expected.