| CARVIEW |
Select Language
HTTP/2 200
date: Thu, 24 Jul 2025 22:21:40 GMT
content-type: text/html; charset=utf-8
cf-ray: 9646cfd6bd5720c5-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=6450d93c-deed-4beb-bd79-bedc7dfbbb2f; expires=Fri, 24 Jul 2026 22:21:40 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 3377dfcb-34c6-411a-b90c-2a8d25f202e1
x-worker-origin-response-time: 521000000
x-dns-prefetch-control: off
set-cookie: prov=6450d93c-deed-4beb-bd79-bedc7dfbbb2f; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=K.DVRVXdHKQn..wjvstV5OULiGGdMlKBwodtrN2ztpM-1753395700-1.0.1.1-kfTg.r5AXgtGWUf3JXtQYMTuik3trkal1qPQV8f0BbiDW4S_wQ87lnpfTyQB4W6LnPyWJ.nsKBRTCLnd8FLGFG5BN.mZeYf7Oz_G0DSQeGU; path=/; expires=Thu, 24-Jul-25 22:51:40 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=nPtMiYfSpKIXldEFLbWt24lAXWruzAJ78ewDItGK90E-1753395700808-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'performance' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [performance]
An evaluation of whether a system works well enough to be fit for purpose. Normally performance refers to the speed with which a system completes an operation or set of operations over time.
6,477 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
14
views
Do you know about a triple store that performs well under frequent CRUD operations?
I'm working with RDF data in real-world applications that require frequent create, update, and delete operations — classic CRUD behavior. However, I’ve noticed that many triple stores seem heavily ...
0
votes
1
answer
20
views
MariaDB: Engine-independent statistics are not collected for column
In the course of optimizing my MariaDB database I have tried the following query (found in this blocg post):
ANALYZE TABLE <my_table> PERSISTENT FOR ALL;
The command runs without an error, ...
1
vote
1
answer
45
views
Postgres query planner join selectivity greater than 1?
I am using PostgreSQL 14.17.
I am trying to debug a query planner failure in a bigger query, but I think I've narrowed down the
problem to a self-join on a join table:
SELECT t2.item_id
FROM ...
1
vote
0
answers
90
views
SLEEP_TASK waits on single-threaded UPDATE that does not generate an in-flight plan, how are these waits possible?
Yesterday, I witnesses a running query in sp_WhoIsActive that I could not explain. It had the following properties:
It ran in a nested transaction. The first transaction bulk inserts into a temp ...
2
votes
0
answers
52
views
What Vector Database is purposed for large data?
I have few hundred millions embeddings with dimensions 512 and 768.
I looking for vector DB that could run similarity search enough fast and with high precision.
I don't want to use server with GPU, ...
3
votes
1
answer
287
views
What are better approaches than loops for frequent operations?
I have to make multiple UPDATE statements, but I'm looking for the best approach to do so, in terms of readability and performance. I looked for another answers but the only thing I found is that &...
0
votes
1
answer
46
views
Indexed Views added to database have increased Parse and Compile time dramatically
Recently, one of our development teams have added some indexed views based on some very commonly used tables. The problem we are getting now is that queries that used to execute quickly are taking a ...
-1
votes
1
answer
136
views
MySQL 8.0.41 - 83 % Waiting for row lock on AO_319474_QUEUE
Environment
We run three Jira Service Management DC clusters that all share the same topology:
MySQL 8.0.36 on Ubuntu 22.04 – 32 vCPU, 100 GB RAM, buffer-pool now 80 GB (only ~33 GB in use), NVMe ...
1
vote
0
answers
55
views
ALTER TABLE ... REORGANIZE PARTITION on huge table takes longer after upgrading to MySQL 8.0
After upgrading from MySQL 5.7 to MySQL 8.0.33, I’ve observed a dramatic slowdown in partition management operations, particularly:
ALTER TABLE ... REORGANIZE PARTITION
ALTER TABLE ... DROP PARTITION
...
1
vote
0
answers
69
views
MariaDB 4-5 times slower than Oracle
since Oracle will increase the costs for running databases my employer is currently evaluating alternatives for oracle databases.
In one application we currently use oracle db with no specific ...
2
votes
1
answer
51
views
Stategies for scaling out MySQL/MariaDB when database gets too large for a single host?
What are your strategies when a MySQL/MariaDB database server grows to have too much traffic for a single host to handle, i.e. scaling CPU/RAM is not an option anymore? Do you deploy ProxySQL to start ...
3
votes
1
answer
65
views
MYSQL and random performance of store procedure
I run this SP at night, when there’s almost no activity. The SP performs an accumulative calculation of machine usage from a laundromat—an artisanal BI query. It writes the result to a table.
On most ...
2
votes
1
answer
46
views
partition table by created - how to avoid pagination problem caused by partition by Created column
I'm dealing with a performance issue on a partitioned table in SQL Server.
⚙️ Table setup:
The table is partitioned by Created (weekly), using a PARTITION SCHEME and PARTITION FUNCTION based on the ...
0
votes
2
answers
121
views
Unexplained read latency in SQL Server despite healthy RAID 10 disk and good synthetic benchmarks
I've set up a SQL Server instance on a dedicated Windows server. The .mdf data file is placed on a dedicated disk configured as RAID 10, with the RAID controller cache ratio set to 90% write / 10% ...
0
votes
3
answers
254
views
How to Insert 150,000 Rows in SQL Server Efficiently? (Error: Max 1000 Row Limit)
I am working with a large dataset of 150,000 rows that needs to be inserted into a SQL Server table. However, I am encountering the following error when trying to insert all values at once using a ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
query-performance × 2440
sql-server × 2104
mysql × 1729
postgresql × 1338
index × 620
optimization × 614
postgresql-performance × 547
performance-tuning × 522
database-design × 348
execution-plan × 315
oracle × 303
sql-server-2012 × 274
innodb × 248
sql-server-2008-r2 × 217
sql-server-2008 × 207
join × 205
index-tuning × 200
sql-server-2014 × 169
sql-server-2016 × 166
t-sql × 154
mariadb × 143
sql-server-2005 × 110
partitioning × 108
mysql-5.5 × 103
memory × 101
more related tags
Hot Network Questions
- Visual glitches on Chrome - but only in some places. What could be the problem?
- Was Hermann Ganswindt's helicopter actually the first manned heavier-than-air motor-powered flight?
- Is the appearance of certain kinds of clouds at altitude of > 30000 feet a recent phenomenon?
- Do things unknown automatically become unknowable in normal epistemic modal logic
- What does this word "ahn-shdah-heh" mean?
- Distance of superdense color code circuits
- How to 'scale' a square list?
- Business technical issues lead to unsuccessful payment being considered successful. Do I have any duty to notify?
- Why is Shunt Voltage Reference (LM4040DBZ-3) Not outputting a stable 3V supply
- How much time should I take for "self transfer" without checked-in baggage?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Etymology of the word skulduggery?
- A word that describes some people
- Expected Value of a Dice Product Game
- What is that "T" in the pattern string of the date-command?
- I am looking for a French mathematician who contributed to complex analysis
- Do standing sound waves sound different?
- How to model This Twisted Torus?
- Interaction with para hooks and footnotes
- Which workflow is more effective: worldbuilding before plotting or the other way around?
- Legolas Master Archer removed with 2nd triggered ability on stack
- Does Philosophy Need Quotes?
- How do Francophones hear "ChatGPT"?
- Huge Difference in Interaction P-values Between Linear vs. Ordinal Regression (0.991 vs. 0.001)