Query Optimizer available?

[Paul]

Is there a query optimiser?

TypeDB has a query optimiser where depending on the number of filters, segregates out the number of rows to traverse before the query is executed. This allows for blazingly fast performance.

Is this ability available within TigerGraph???

Here is an example where a QO does not exist. I was previously working with Dgraph. The issue outlined here (from another user who encountered similar performance issues): Soft deleting nodes + query performance - Dgraph - Discuss Dgraph

More and more filtering means that execution time (possibly) increases linearly? But at a minimum it does not decrease.

So what is the current case? Thanks

[Jon_Herke]

Hi @Paul,

Currently TigerGraph doesn’t have a tool that can take a query then automatically optimize the query. However, this does seem like an interesting project that would be feasible. I’ll have my team take a look at scoping out such a project.

These two videos talk about best practices in writing GSQL.

GSQL SCHEMA DESIGN & QUERY WRITING BEST PRACTICES: Part 1: Schema Design Best Practices

GSQL SCHEMA DESIGN & QUERY WRITING BEST PRACTICES: Part 1: Schema Design Best Practices

TigerGraph GSQL Query Writing Best Practices

GSQL SCHEMA DESIGN & QUERY WRITING BEST PRACTICES: Part 2: Query Writing Best Practices