article thumbnail

HammerDB Best Practice for PostgreSQL Performance and Scalability

HammerDB

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . CPUs which run at the same hardware frequency: 0. hammerdbcli.

article thumbnail

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. driver: intel_pstate CPUs which run at the same hardware frequency: 0 . hardware limits: 1000 MHz - 3.80 hardware limits: 1000 MHz - 3.80 current CPU frequency: Unable to call hardware .

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

Rethinking the 'production' of data

All Things Distributed

That was the provocative thesis of a much-talked-about article from 2003 in the Harvard Business Review by the US publicist Nicolas Carr. The benefit for customers: Authorized users can view this data and therefore manage their inventories across different sites, making the maintenance processes much more efficient.

article thumbnail

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52
article thumbnail

Being Practical

Tim Kadlec

Nick Finck and Steve Champeon first coined the term “progressive enhancement” in 2003. As with anything, the more you learn the quicker the process will go. guiding principle, richness: Another thing to keep in mind about richness, as a developer, is that you’re probably not the average user. Here at Yahoo!, That was 2008.

Google 40
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

DBCC Page Auditing DBCC page auditing is the process of executing common DBCC consistency checks as pages are read from disk. ​​ This is a serious I/O subsystem problem that should be addressed immediately to avoid SQL Server and overall system stability problems ​​ and ​​ data loss.

Servers 40