Forum Discussion
Microsoft optimization suggestion - using a shared query
- 1 year ago
Hi jaryszek
Sorry for the delayed reply.
Absoluletly, that would be the right order of query execution.
Did it work ? π A kudos would be appreciated ββπ’ Mark it as a solution to help spreading knowledge
Hi jaryszek
Itβs better because it keeps things clean and modular, by using that apporach you will be defining the environment specific path once, then reference it across queries, no hardcoding, no repetition, and if the path changes, you only update it in one place.
Itβs easier to manage, less error-prone, and much more scalable across projects or environments.
Did it work ? π A kudos would be appreciated ββπ’ Mark it as a solution to help spreading knowledge
Thank you, so it means that
SyntheticBasePath
will be used only once at the top of other queries? And order will be :
1) calculate shared query
2) put it into memory
3) used by other queries
??
Best,
Jac
- DataVitalizer1 year agoSuper User
Hi jaryszek
Sorry for the delayed reply.
Absoluletly, that would be the right order of query execution.
Did it work ? π A kudos would be appreciated ββπ’ Mark it as a solution to help spreading knowledge- jaryszek1 year agoSuper User
thank you!