Remove 2014 Remove Availability Remove Cache Remove Storage
article thumbnail

Cache-Control for Civilians

CSS Wizardry

To this end, having a solid caching strategy can make all the difference for your visitors. ?? How is your knowledge of caching and Cache-Control headers? That being said, more and more often in my work I see lots of opportunities being left on the table through unconsidered or even completely overlooked caching practices.

Cache 264
article thumbnail

AMD EPYC Processors in Azure Virtual Machines

SQL Performance

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. The L3 cache size is 64MB.

Azure 42
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Minimal Logging with INSERT…SELECT into Empty Clustered Tables

SQL Performance

If both sort and no-sort alternatives are available, the optimizer will make a cost-based choice. For SQL Server 2014 and later, the uniquifier is correctly omitted for unique indexes, but the one extra byte for the internal bit flag is retained. spt_values AS SV ; Plan Caching. Type id 56 integer = 4 bytes ( id column).

Cache 67
article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

MariaDB retains compatibility with MySQL, offers support for different programming languages, including Python, PHP, Java, and Perl, and works with all major open source storage engines such as MyRocks, Aria, and InnoDB. Scalability and replication options that can improve performance and high availability.

article thumbnail

Progress Delayed Is Progress Denied

Alex Russell

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. The information it captures is, however, available going back somewhat further, providing a fuller picture of the trend lines of engine completeness. Count of APIs available from JavaScript by Web Confluence.

Media 145
article thumbnail

The Performance Inequality Gap, 2021

Alex Russell

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Modern network performance and availability. mid-priced Androids were slightly faster than 2014's iPhone 6. The Moto G4 , for example. Here begins our 2021 adventure. Hard Reset.

article thumbnail

Minimal Logging with INSERT…SELECT and Fast Load Context

SQL Performance

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. GO. -- Clear the plan cache. There is a final condition evaluated by storage engine code ( IndexDataSetSession::WakeUpInternal ) at execution time: DMLRequestSort is currently true ; and. GO. -- Clear the plan cache. DETAILED'. )

Cache 64