Tag: optimization


Found 944 results for 'optimization'.


1) c++ - What is copy elision and how does it optimize the copy-and-swap idiom?
2) c++ - How does const after a function optimize the program?
3) mysql - Optimizing a simple query on a large table
4) mysql - Simple query is slow on 4M-rows table
5) postgresql - PostgreSQL 9.5 query performance depends on JOINed column in SELECT clause
6) mysql - Mysql Query takes forever after adding a where condition
7) postgresql - > 30 sec slow query
8) postgresql - Schema for analytics table in Postgres
9) postgresql - Optimize query to find top N users who commented on a post
10) sql-server - Is there an efficient way to match multiples headers that have the same set of details?
11) postgresql - How to index WHERE (start_date >= '2013-12-15')
12) postgresql - postgres explain plan with giant gaps between operations
13) mysql - Nested json response from 3 one to many tables
14) mysql - What would be most elegant way to replicate data contents periodically into a MySQL table?
15) sql-server - Updating a table efficiently using JOIN
16) sql-server - Efficiency of Scalar UDF vs TVF
17) mysql - Optimize slow COUNT in MySQL subquery
18) postgresql - PostgreSQL planner not using PK index
19) postgresql - PostgreSQL tree structure and recursive CTE optimization
20) sql-server - Why doesn’t this recursive CTE with a parameter use an index when it does with a literal?
21) postgresql - Join external data in SELECT query
22) mysql - Efficient workflow/queries to save unique information?
23) mysql - Should JSON columns be separate from a wide table in MySQL?
24) c - C loop optimization help for final assignment (with compiler optimization disabled)
25) postgresql - Why is PostgreSQL 9.5 not using my newest index for ORDER BY, even though it uses similar indices just fine?
26) postgresql - PostgreSQL IN query performance on a larger array
27) sql-server - Bulk Data Loading and Transaction Log
28) python - How do I profile a Python script?
29) sql-server - SQL Server Snapshot Isolation Level: How to create an Update Conflict?
30) postgresql - How to manipulate join order of PostgreSQL optimizer?
31) sql-server - Why high compile times for functions with XML on SQL Server 2016?
32) mysql - Is this query too slow regarding the job it is doing?
33) performance - Performance optimization strategies of last resort
34) php - Is micro-optimization worth the time?
35) postgresql - What is the best way to store large lists of user statistics?
36) linux - Why rsync is faster than NFS?
37) encryption - Ciphertext packing for bandwidth optimization
38) implementation - Lookup table for DSA/ECDSA/Schnorr multiplication
39) ssd - SSD optimization
40) oracle - Indexing strategy for VARCHAR2 LIKE search
41) c - Improve INSERT-per-second performance of SQLite
42) mysql - MySQL - How do I Calculate an Average Value Over a Period of Time When Only Value Changes are Recorded
43) postgresql - Is normalizing further to index on INT FK rather than VARCHAR worth it?
44) postgresql - Does the order of fields in SELECT query matter when using composite indexing?
45) postgresql - Do covering indexes in PostgreSQL help JOIN columns?
46) mysql - Storing files with extension in database as BLOB
47) c - Is "==" in sorted array not faster than unsorted array?
48) c++ - Why does C++ code for testing the Collatz conjecture run faster than hand-written assembly?
49) c++ - gcc optimization flag -O3 makes code slower than -O2
50) mysql - Building a 1,000M row MySQL table