go to post Robert Cemper · Jul 22, 2017 If there is an index defined on PBD_PBO_ParRef is it correctly generated?If not sure, do rebuild index from MgmtPortal.
go to post Robert Cemper · Jul 21, 2017 What about chopping your query like this or similarlastID=0"Select TOP 10000 ID,Text from eprinstance.isegment where ID > ?"passing lastID as query ParameterNow you loop on it until you collected all records.The basic idea is to limit your result set by TOP as your partition allows. it's definitely independent of Cache versions.
go to post Robert Cemper · Jul 21, 2017 I wish I had this half a year ago when I was teaching Caché basics to total fresh developers.Great stuff.Robert
