Persistance de donnéesMySQL indexes are often used to make performance better. However, they can make performance suffer if you are not using them properly. Oracle ACE Director Sheeri Cabral explains the pitfalls to avoid with indexes and how to utilize compound indexes to maximize index availability with the least amount of write overhead.
Persistance de donnéesDatabase servers have hardware requirements different from other infrastructure software, specifically unique demands on I/O and memory. This presentation covers these differences and various I/O options and their benefits. Topics include solid-state drives (SSD), battery-backed RAID, controllers, and caching.
Persistance de donnéesDealing with lots of data can be daunting, if not done well it can affect the performance of your applications. Data has business value though and can't be ignored.
Storing it, dealing with it and mining it have huge rewards and can be fun. I'll cover some theory but the emphasis will be on the practical.
Persistance de donnéesIn this presentation, Sheeri Cabral will explain the differences and similarities among Oracle's MySQL, MariaDB, Drizzle, and the Percona patchset. You will learn the coding philosophies of the organizations behind the software, and how they interact with the community, so you can choose which fork is right for you.
Persistance de donnéesES provides an easy path to full-text search, synonyms, faceting, and geographic math, but there's a paucity of written wisdom beyond its API docs. This talk provides a survey of its capabilities and dives into the practical tradeoffs in a high-volume ES system, from indexing structures to the realities of deployment. Outline: http://bit.ly/OQxMje
Persistance de donnéesPostgresSQL contains a very rich set of datatypes, richer than most other databases. Some are built into the core PostgreSQL, some are available as easy to install extensions. This means that if you choose and use the correct datatype, you get lots of additional functionality in your system, completely for free.
Persistance de donnéesPostgreSQL 9.1 arrived with a new featured called KNN-GiST, or fast K-Nearest-Neighbour searching. Many people don't realize what that means, and what they're good for. This walk will look into both the more obvious geometrical and geographical cases, as well as the more surprising use-cases such as string matching and similarity
Persistance de donnéesThis talk introduces MongoDB. I will cover MongoDB's basic functionality, but also introduce replication and sharding. Focussing mostly on schema design and indexing gives you a solid base to get started with this scalable and high-performance document-oriented NoSQL database but also understand the design principles and use-cases.
Persistance de donnéesNeo4j is a Java-based server to manage graphs of data. Nodes and edges - thinks people and friendship relations. This session will present the libraries available in PHP to communicate with this NoSQL server along with a few general strategies to use them efficiently to create well performing applications.
Persistance de donnéesEmailing *.sql files to the in-house DBA before each release used to work for your single-node, single-environment website. You have recently been tasked with building a multi-environment application architecture when you realize that you need to come up with a more professional process which is less error-prone.
Persistance de donnéesPHP and MySQL are the foundation of many web applications. Still many developers scratch only the surface of the provided interoperability between PHP and MySQL. In this session you will learn hidden gems and new features in these area both on PHP's and MySQL's side. Things like automatic load balancing or caching features or memcache integration.
Persistance de donnéesMore than some arcane NoSQL tool, Redis is a simple but powerful swiss army knife you can begin using today.
This talk introduces Redis and focuses on using it to cleanly solve everyday problems. Along the way, you'll learn how Redis can be used as an alternative to several common PHP tools.
Persistance de donnéesThe MySQL database is fast but still system performance has limits. For read-load MySQL's replication system is a known and proven way for scaling out. But what about write-loads? This session will discuss the latest state about sharding in MySQL. From a basic setup to later shard management an further improvements.
Persistance de donnéesThis talk explores the much-anticipated Postgres 9.0 features of hot standby and streaming replication. It explains how these features work, how to configure them, and their current limitations. It includes a hands-on demonstration that can be done either by the instructor or by students.
Pour offrir une bonne expérience, l'utilisation de cookies est nécessaire. Certains sont essentiels au bon fonctionnement du site, tandis que d'autres nous aident à mieux répondre à vos intérêts.