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?
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.