-
- 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)
-
- 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.