Remove 2000 Remove Benchmarking Remove Cache Remove Testing
article thumbnail

Impact of Querying Table Information From information_schema

Percona

A lot of useful information can be retrieved from this schema, for example, table metadata and foreign key relations, but trying to query I_S can induce performance degradation if your server is under heavy load, as shown in the following example test. The same tests have been executed in Percona Server for MySQL 5.7

Cache 104
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Books Online (BOL) References: ​​ All BOL references cited in this paper are taken from the Microsoft SQL Server 2000 Books Online site (updated to include SP3 functionality), which can be found at: [link] Click the Product Documentation link. This cache is often supported by a battery-powered backup facility.

Servers 40
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

Progress Delayed Is Progress Denied

Alex Russell

As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. With each team, benchmarks lost are understood as bugs. All modern browsers are fast, Chromium and Safari/WebKit included. Lower is better.

Media 145
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

The ​​ SQL Server 2000 I/O Basics ​​ document is a prerequisite to ​​ the information contained in this ​​ document. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40