Insights
Lessons From
the Work.
Perspectives for technology leaders and practical engineering notes from the teams who build, modernize, and run enterprise systems.
Let’s talk indexes
Databases handle thousands or even millions of records, and they need to be able to return results in milliseconds. Thus, it is imperative to optimize data fetching: indexes. This article explains indexes and how to implement them in OutSystems.
How to handle hierarchical data using advanced queries
Have you ever been faced with a hierarchical data tree where you need to get a specific path or make a validation before adding/editing a node? In this post, we’ll show you how to do that by using CTEs / CONNECT BY on advanced queries on SQL and Oracle.
How to optimize your queries in Outsystems: the ‘max records’ property
To show you how you can optimize your queries to fetch only the records you want or how to apply some logic to manage heavy tables, let’s go on a trip where we’ll visit our beloved aggregates and, the ones feared by many, SQL queries.