Stories tagged with Performance - DeveloperSites
1
likes
spam Like Dislike

When and When Not To Use NOLOCK

published 18 days, 18 hours, 30 minutes ago posted by matthewpomarmatthewpomar 28 days, 16 hours, 41 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 3:06:48 PM GMT
To NOLOCK or Not to NOLOCK... That is the question. Lots of developers who don't fully understand the requirements of their application or how NOLOCK works will indiscriminately add NOLOCK to all of the SQL queries. But doing so isn't always the best decision. Brent Ozar describes some times when it is beneficial to use NOLOCK and times where it isn't the right choice. (more)
category: SQL Server | clicked: 0 | comment | | source: www.brentozar.com
tags: MS SQL, Performance
1
likes
spam Like Dislike

9 Django Tips for Working with Databases

published 28 days, 15 hours, 4 minutes ago posted by matthewpomarmatthewpomar 37 days, 17 hours, 34 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 2:14:17 PM GMT
ORMs offer great utility for developers but abstracting access to the database has its costs. Developers who are willing to poke around the database and change some defaults often find that great improvements can be made. (more)
category: Django | clicked: 1 | comment | | source: hakibenita.com
tags: ORM, Performance, PostgreSQL, SQL
1
likes
spam Like Dislike

Be Careful With CTE in PostgreSQL

published 28 days, 15 hours, 4 minutes ago posted by matthewpomarmatthewpomar 37 days, 18 hours, 15 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:32:43 PM GMT
PostgreSQL, SQL, PerformanceHow to avoid common pitfalls with common table expressions in PostgreSQL Common table expressions (CTE), also known as the WITH clause, are a very useful feature. They help break down big queries into smaller pieces which makes it easier to read and understand. PostgreSQL Version This article is intended for PostgreSQL versions 11 and prior. Starting at version 12, PostgreSQL changed the way it treats CTE to prevent the issues described in this article.Wha... (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

How We Solved a Storage Problem in PostgreSQL Without Adding a Single Byte of Storage

published 28 days, 15 hours, 4 minutes ago posted by matthewpomarmatthewpomar 37 days, 18 hours, 18 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:29:44 PM GMT
A while back we started getting alerts in the middle of the night on low disk space. A quick investigation led us to one of our ETL tasks. Every night the task was fired to eliminate duplicate dumps, and free up some space. This is a short story about how we found our silver bullet and solved the issue without adding a single byte of storage. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

Fastest Way to Load Data Into PostgreSQL Using Python

published 28 days, 15 hours, 4 minutes ago posted by matthewpomarmatthewpomar 37 days, 18 hours, 30 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:18:20 PM GMT
Explore the best way to import messy data from remote source into PostgreSQL using Python and Psycopg2. The data is big, fetched from a remote source, and needs to be cleaned and transformed. (more)
category: PostgreSQL | clicked: 1 | comment | | source: hakibenita.com
tags: Performance, Python
1
likes
spam Like Dislike

12 Common Mistakes and Missed Optimization Opportunities in SQL

published 28 days, 15 hours, 4 minutes ago posted by matthewpomarmatthewpomar 37 days, 18 hours, 35 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:12:55 PM GMT
SQL is used by analysts, data scientists, product managers, designers and many others. These professionals have access to databases, but they don't always have the intuition and understanding to write efficient queries. In an effort to make my team write better SQL, I went over reports written by non-developers and code reviews, and gathered common mistakes and missed optimization opportunities in SQL. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance

published 28 days, 15 hours, 4 minutes ago posted by matthewpomarmatthewpomar 37 days, 18 hours, 48 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 1:00:22 PM GMT
Any database schema is likely to have plenty of text fields. In this article I demonstrate the surprising impact of medium-size texts on query performance. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL
1
likes
spam Like Dislike

Re-Introducing Hash Indexes in PostgreSQL

published 28 days, 15 hours, 4 minutes ago posted by matthewpomarmatthewpomar 37 days, 18 hours, 49 minutes ago
Sunday, December 19, 2021 4:44:10 PM GMT Friday, December 10, 2021 12:59:22 PM GMT
There is a type of index you are probably not using, and may have never even heard of. It is wildly unpopular, and until a few PostgreSQL versions ago it was highly discouraged and borderline unusable, but under some circumstances it can out-perform even a B-Tree index. (more)
category: PostgreSQL | clicked: 0 | comment | | source: hakibenita.com
tags: Performance, SQL