Idle Time Server Side Sort Optimization

Idea created by oceanwest on Mar 3, 2016
    Active
    Score2
    • 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.

     

    Idea:

    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.