#sqloptimization — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqloptimization, aggregated by home.social.
-
Why does this SQL json index fail?
Why does this SQL JSON index fail in production. The SQL code stores JSON as text and queries with LIKE, so indexes are never used. In SQL services this becomes a performance trap.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqlindex #sqlquery #sqloptimization
-
Why does this SQL json index fail?
Why does this SQL JSON index fail in production. The SQL code stores JSON as text and queries with LIKE, so indexes are never used. In SQL services this becomes a performance trap.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqlindex #sqlquery #sqloptimization
-
Why does this SQL json index fail?
Why does this SQL JSON index fail in production. The SQL code stores JSON as text and queries with LIKE, so indexes are never used. In SQL services this becomes a performance trap.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqljson #sqlindex #sqlquery #sqloptimization
-
#OdooDevelopment #SQLOptimization | Struggling with complex SQL queries in your Odoo modules? Learn how Common Table Expressions can dramatically improve performance and code readability. This comprehensive guide includes real-world examples, best practices, and implementation techniques. @odoo
https://teguhteja.id/odoo-sql-cte-optimize-database-performance-postgresql-queries/