mastodontech.de ist einer von vielen unabhängigen Mastodon-Servern, mit dem du dich im Fediverse beteiligen kannst.
Offen für alle (über 16) und bereitgestellt von Markus'Blog

Serverstatistik:

1,4 Tsd.
aktive Profile

#databaseoptimization

0 Beiträge0 Beteiligte0 Beiträge heute
zartom<p>Finding the First Match of Names in a Large Database<br>Optimize DB2 LUW queries for speed! Find the first match of a name in a large table using ROW_NUMBER() window function. Avoid fetching all matches. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/ROW_NUMBER" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ROW_NUMBER</span></a> <a href="https://mastodon.social/tags/WindowFunctions" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WindowFunctions</span></a> <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a> <a href="https://mastodon.social/tags/QueryPerformance" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>QueryPerformance</span></a><br><a href="https://tech-champion.com/programming/finding-the-first-match-of-names-in-a-large-database/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/programming/</span><span class="invisible">finding-the-first-match-of-names-in-a-large-database/</span></a><br>...</p>
Hacker News<p>Selective async commits in PostgreSQL – balancing durability and performance</p><p><a href="https://www.shayon.dev/post/2025/75/selective-asynchronous-commits-in-postgresql-balancing-durability-and-performance/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">shayon.dev/post/2025/75/select</span><span class="invisible">ive-asynchronous-commits-in-postgresql-balancing-durability-and-performance/</span></a></p><p><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/SelectiveAsyncCommits" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SelectiveAsyncCommits</span></a> <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://mastodon.social/tags/Durability" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Durability</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Performance</span></a> <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a> <a href="https://mastodon.social/tags/TechNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TechNews</span></a></p>
Hacker News<p>BM25 in PostgreSQL – 3x Faster Than Elasticsearch — <a href="https://blog.vectorchord.ai/vectorchord-bm25-revolutionize-postgresql-search-with-bm25-ranking-3x-faster-than-elasticsearch" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.vectorchord.ai/vectorchor</span><span class="invisible">d-bm25-revolutionize-postgresql-search-with-bm25-ranking-3x-faster-than-elasticsearch</span></a><br><a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/BM25" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>BM25</span></a> <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://mastodon.social/tags/Elasticsearch" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Elasticsearch</span></a> <a href="https://mastodon.social/tags/FastSearch" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FastSearch</span></a> <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a></p>
Tuvoc Technologies<p>How to Choose the Right Database for Your Web Application in 2025: Top 10 Options</p><p><a href="https://www.tuvoc.com/blog/how-to-choose-the-right-database-for-your-web-application-in-2025-top-10-options/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">tuvoc.com/blog/how-to-choose-t</span><span class="invisible">he-right-database-for-your-web-application-in-2025-top-10-options/</span></a></p><p>Discover the top 10 database options for web applications in 2025. Learn how to choose the right database based on performance, scalability, and security needs.</p><p><a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a> <br><a href="https://mastodon.social/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WebDevelopment</span></a><br><a href="https://mastodon.social/tags/TechTrends2025" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TechTrends2025</span></a> <br><a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a><br><a href="https://mastodon.social/tags/NoSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NoSQL</span></a> <br><a href="https://mastodon.social/tags/CloudDatabase" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CloudDatabase</span></a><br><a href="https://mastodon.social/tags/ScalableTech" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ScalableTech</span></a> <br><a href="https://mastodon.social/tags/SoftwareDevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SoftwareDevelopment</span></a><br><a href="https://mastodon.social/tags/BackendDevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>BackendDevelopment</span></a> <br><a href="https://mastodon.social/tags/DataManagement" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataManagement</span></a><br><a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <br><a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a><br><a href="https://mastodon.social/tags/MongoDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MongoDB</span></a> <br><a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a><br><a href="https://mastodon.social/tags/FutureTech" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FutureTech</span></a></p>
zartom<p>Database Query Optimization: Speeding Up Slow Queries<br>Database Query Optimization is crucial for app performance. Learn advanced techniques like indexing, data type optimization, and using CTEs to boost query speeds. <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a> <a href="https://mastodon.social/tags/QueryTuning" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>QueryTuning</span></a> <a href="https://mastodon.social/tags/SQLTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQLTips</span></a> <a href="https://mastodon.social/tags/DataScience" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.social/tags/PerformanceBoost" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PerformanceBoost</span></a> <a href="https://mastodon.social/tags/BigData" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>BigData</span></a><br><a href="https://tech-champion.com/database/database-query-optimization-speeding-up-slow-queries/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/dat</span><span class="invisible">abase-query-optimization-speeding-up-slow-queries/</span></a><br>Learn how to optimize slow database queries. This guide covers indexing join condition improvements and ca...</p>
zartom<p>Composite Primary Keys: When Simplicity Trumps Complexity in Database Design<br>Optimizing database design: Single vs. composite primary keys. For smaller databases, a single, auto-incrementing primary key often offers superior performance &amp; maintainability. Simplicity trumps complexity! Composite primary keys add complexity to updates &amp; queries. <a href="https://mastodon.social/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseDesign</span></a> <a href="https://mastodon.social/tags/PrimaryKey" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PrimaryKey</span></a> <a href="https://mastodon.social/tags/CompositeKey" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CompositeKey</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Performance</span></a><br><a href="https://tech-champion.com/database/db2luw/composite-primary-keys-when-simplicity-trumps-complexity-in-database-design/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/composite-primary-keys-when-simplicity-trumps-complexity-in-database-design/</span></a></p>
LavX News<p>Unlocking the Secrets of NUMA: How Expensify Mastered Extreme Concurrency</p><p>In the world of high-performance computing, few concepts are as enigmatic as Non-Uniform Memory Access (NUMA). Expensify's deep dive into their NUMA balancing techniques reveals how they harness this ...</p><p><a href="https://news.lavx.hu/article/unlocking-the-secrets-of-numa-how-expensify-mastered-extreme-concurrency" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">news.lavx.hu/article/unlocking</span><span class="invisible">-the-secrets-of-numa-how-expensify-mastered-extreme-concurrency</span></a></p><p><a href="https://mastodon.social/tags/news" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>news</span></a> <a href="https://mastodon.social/tags/tech" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tech</span></a> <a href="https://mastodon.social/tags/NUMABalancing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NUMABalancing</span></a> <a href="https://mastodon.social/tags/HighPerformanceComputing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HighPerformanceComputing</span></a> <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a></p>
Brieflur<p>Boost MySQL performance with 10 proven MySQL query optimization tips. Learn to reduce load times and maximize efficiency.</p><p><a href="https://brieflur.com/mysql-query-optimization-10-proven-tips-for-peak-performance/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">brieflur.com/mysql-query-optim</span><span class="invisible">ization-10-proven-tips-for-peak-performance/</span></a></p><p><a href="https://mastodon.social/tags/TechTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TechTips</span></a><br><a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a><br><a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a><br><a href="https://mastodon.social/tags/PerformanceBoost" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PerformanceBoost</span></a> <br><a href="https://mastodon.social/tags/CodingBestPractices" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CodingBestPractices</span></a><br><a href="https://mastodon.social/tags/developers" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>developers</span></a> <a href="https://mastodon.social/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>programming</span></a></p>
acanimal<p>Explore the art of SQL query refinement with this all-encompassing guide for developers. Dive into techniques for enhancing database performance. <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> <a href="https://techhub.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a> <a href="https://buff.ly/4gvEBtt" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">buff.ly/4gvEBtt</span><span class="invisible"></span></a></p>
IB Teguh TM<p>"Unlock advanced data analysis with SQL subqueries. Discover how nested queries can transform your database operations. Practical examples and expert tips included. <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a></p><p><a href="https://teguhteja.id/sql-subqueries-mastering-advanced-data-analysis/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">teguhteja.id/sql-subqueries-ma</span><span class="invisible">stering-advanced-data-analysis/</span></a></p>
Remkus de Vries<p>2/ 🛠️&nbsp;Switch to a Modern Storage Engine</p><p>Consider switching your database storage engine to InnoDB if you haven't already. InnoDB supports row-level locking and transactions, making it ideal for high-concurrency environments typical in busy online stores. <a href="https://social.devries.frl/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a> <a href="https://social.devries.frl/tags/InnoDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>InnoDB</span></a></p>
IB Teguh TM<p>Discover how Redis Lua scripting revolutionizes transaction handling and improves application performance. Practical guide with code examples and implementation strategies. <a href="https://mastodon.social/tags/Redis" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Redis</span></a> <a href="https://mastodon.social/tags/DatabaseOptimization" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseOptimization</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.social/tags/Development" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Development</span></a></p><p><a href="https://teguhteja.id/redis-lua-scripting-guide-for-atomic-transactions/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">teguhteja.id/redis-lua-scripti</span><span class="invisible">ng-guide-for-atomic-transactions/</span></a></p>