|
Currently the fact-paths endpoint needs to join facts, fact_paths, fact_values, and fact_value_types, then do a distinct over them. This is causing performance issues for some large customers and slow queries have also been noted in scale testing.
If it's the case the the console is using only the fact path out of the response, and throwing the type away, then they are likely receiving duplicate data despite the distinct (paths shared for multiple types) and the database is doing much more work than necessary. In contrast, a select * from fact_paths will always return deduplicated paths and will be much faster. If this would suit the needs of the console a separate endpoint might be warranted.
|
