We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 18397
    • 3,250 Posts
    Ok, after much work I have discovered several things:

    1. The two MAJOR things slowing Ditto down are fetching the TV output and retrieving the content field.
    2. Fetching only the raw TV (not output formatted) shaves the TV fetch time by half.
    3. Removing the content field from the SQL cuts the query time in half.

    So, here are the solutions in the next version of Ditto.

    [DONE]
    Option to toggle TV data or output
    Limit and where parameters for custom optimizatoin
    Overhaul as to how Ditto retrieves documents

    [INPROGRESS]
    Only retrieve content when neccessary
    Get TVs and content after the main array so that they are only retrieved when being displayed (unless a filter or adv. sort is being used)
      • 18397
      • 3,250 Posts
      Another performance related discovery! The API Ditto uses to getTemplateVars only works one document at a time and thus requires one query for every document rather than the preferred one query for all documents.