Performances tuning for reading data from a HExecuteSQLQuery.
// you need to execute the query first
HExecuteSQLQuery (MaRequete)
//Cache de 1000 enregistrements
ASProperty (MaRequete, "CACHESIZE", "1000")
ASProperty (MaRequete, "FORWARDONLY", "1")
Performance gain can theoretically be up to 50% on the reading of resulting data.