Unsolved
This post is more than 5 years old
4 Posts
0
3414
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?
gstuartemc
417 Posts
1
November 9th, 2010 05:00
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.