Remove c
article thumbnail

HammerDB: Using MySQL 5.7 vs 8.0 to understand performance profiles

HammerDB

One of the most important concepts in analysing database performance is that of understanding scalability. Plotting these data points enables us to understand the scalability of the database software being tested on that system. In particular, this means as we add CPU cores and increase the system load, we see higher performance.

article thumbnail

Why Tcl is 700% faster than Python for database benchmarking

HammerDB

So instead we are going to take a cut down version of the HammerDB TPROC-C driver script and do the same in Python and use the HammerDB infrastructure to measure performance. (We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test). usr/local/bin/tclsh8.6

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

HammerDB Concepts and Architecture

HammerDB

This article Threads Done Right… With Tcl gives an excellent overview of these capabilities and it should be clear that to build a scalable benchmarking tool this thread performance and scalability is key. These bin and lib directories are not included with the source code. You can download and compile TCL/TK 8.6

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. He had it up and running on Wednesday. that a lot of people used.

Tuning 52
article thumbnail

Data Mining Problems in Retail

Highly Scalable

Although these problems are very different, we are trying to establish a common framework that helps to design optimization and data mining tasks required for solutions. The design of the model heavily depends on the problem. This model helps to design targeted usage expansion campaigns. Propensity to category expansion.

Retail 152
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

​​ With new ​​ innovations ​​ come ​​ new terms, designs, ​​ and ​​ algorithms. This is different from ​​ the reference count design ​​ that was ​​ used in SQL Server 7.0 and ​​ 2000.

Servers 40