We wanted to get a list of Content Instances using search a string that matches with certain fields.
When we used ContentInstanceDBQuery and ContentInstanceWhereClause, it was having perfornance issues(taking around 3-4 mins) when fetching more than 1000 records.
Is there a better way to do this with an improved performance(faster resonse time)?
We are only doing a fetch with this, no update or anything like that with the fetched data. So if a plain JDBC work better, we can do that as well.
Thanks
