Hi, When you are in need of a big performance gain retrieving some data you can use the OQL retrieve. IDataTable table = Core.retrieveOQLDataTable(getContext(), textrequest); However we also encountered some limitations when using this select on a Oracle database. The number of results was limited, and if you search for a string value the string size was also limited. Currently I want to know the limitations of the OQL retrieve, some will be database dependent and some will be limitations from the Mendix API