Optimization for large databases

Full-text catalogue support has been added to the search code front and back, providing significant speed improvements to the core search functionality.

Paging of large result sets has been improved, particular in the back end. Consequently the orders view, and other sections that contain many thousands of records are now much sharper in response. Furthermore, the paging controls have been modified to provide adaptable 'next/previous' link functionality based on the number of pages, to avoid huge numbers of page links.

Caching has been improved too on many front and back end sections to reduce round trips to the database, especially on controls used on most pages, or that have complex underlying queries and seldomly changed data.

These features are available from 1.0019 onwards.