Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
dmv.community is one of the many independent Mastodon servers you can use to participate in the fediverse.
A small regional Mastodon instance for those in the DC, Maryland, and Virginia areas. Local news, commentary, and conversation.

Administered by:

Server stats:

170
active users

dmv.community: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.4

#stringconcatenation

1 post1 participant0 posts today
zartom<p>How to Overcome the Listagg Limit of 4000 Characters<br>Overcome the LISTAGG limit in SQL for large datasets! Strategies like chunking and recursive CTEs help manage massive concatenated strings. Learn practical solutions for efficient SQL queries. <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/LISTAGG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LISTAGG</span></a> <a href="https://mastodon.social/tags/StringConcatenation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringConcatenation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLQueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLQueries</span></a> <a href="https://mastodon.social/tags/LargeDatasets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LargeDatasets</span></a><br><a href="https://tech-champion.com/database/how-to-overcome-the-listagg-limit-of-4000-characters/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/how</span><span class="invisible">-to-overcome-the-listagg-limit-of-4000-characters/</span></a><br>...</p>
Sascha Stumpler<p>String concatenation performance boosting <a href="http://dlvr.it/THz0L1" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">http://</span><span class="">dlvr.it/THz0L1</span><span class="invisible"></span></a> via PlanetPowerShell <a href="https://hessen.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://hessen.social/tags/PowerShell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PowerShell</span></a> <a href="https://hessen.social/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://hessen.social/tags/StringConcatenation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringConcatenation</span></a></p>
michabbb<p>To double quote or not, that's the question!</p><p>🔍 <a href="https://social.vivaldi.net/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a> string interpolation occurs at compile-time, not runtime</p><p>🏎️ <a href="https://social.vivaldi.net/tags/SingleQuotes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SingleQuotes</span></a> vs <a href="https://social.vivaldi.net/tags/DoubleQuotes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DoubleQuotes</span></a> debate: negligible performance difference</p><p>💻 <a href="https://social.vivaldi.net/tags/OPcache" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OPcache</span></a> is crucial for optimizing PHP performance</p><p>🔧 <a href="https://social.vivaldi.net/tags/Lexer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Lexer</span></a> handles string interpolation during tokenization</p><p>🧠 <a href="https://social.vivaldi.net/tags/AST" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AST</span></a> and opcode generation treat single and double quotes similarly</p><p>📊 <a href="https://social.vivaldi.net/tags/StringConcatenation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringConcatenation</span></a> options: interpolation, comma separation, or dot operator</p><p>Key takeaway: Use the latest <a href="https://social.vivaldi.net/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a> version, enable <a href="https://social.vivaldi.net/tags/OPcache" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OPcache</span></a>, and choose quotes based on readability, not micro-optimizations. </p><p><a href="https://dev.to/realflowcontrol/too-double-quote-or-not-thats-the-question-78l" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.to/realflowcontrol/too-dou</span><span class="invisible">ble-quote-or-not-thats-the-question-78l</span></a></p>
ExploreLive feeds
About