The Preset Limit 5000 Was Exceeded
ColbornC 270000HFA0 Visits (10065)
Any customer with a large database has run into the famous preset limit of 5000 was exceeded error message. There are a few ways around this message, increasing the size of the fetch stop limit. This workaround will not always work as it is a global setting and who wants large result sets across all applications for all users. Another option is to decrease the size of the result set itself by adding further information to filter information as needed. Good option but it we don't always have the option to filter out information into smaller results sets. Such as when a crontask runs, it will look at all the records and if the result set it too large you receive the error message.
A great work around the preset limit of 5000 is to use the mxe.
In the system properties application bring up the mxe.