Idle Time Server Side Sort Optimization

Idea created by oceanwest on Mar 3, 2016
    • oceanwest
    • Vincent_L

    It is known that a database that has a "natural" sort order performs faster, in some cases we have had to export all data and reimport all data sorted in the desire order to improve performance.



    Some way to indicate at the table level or relationship level ( when sorts are enabled on the table occurrence )  that when the database is idle the server would at some low level internally organize / re-index the data to improve performance. Or some server side schedule that internally performs this task on a hosted database, after the desired tables and sort orders have been setup, and only executes when no users are logged in to the database.