Advanced Database Interactions with HyperDB

This is the continuation post of my previous post “Advanced Database classes for WordPress“. Please read that post before continue unless you are not familiar with advanced database classes for WP.

Well, it’s time to see some configurations and ideas about how Hyper-DB or relevant DB classes might help you to scale.

Continue reading “Advanced Database Interactions with HyperDB”
Advertisements

Advanced Database classes for WordPress

Let’s talk about WordPress’ advanced database classes. I’m explicitly mentioning HyperDB, but there are other alternatives/forks out there;

Continue reading “Advanced Database classes for WordPress”

Fast data import trick

useful information about restoring large databases 👍

gabi.dev

A few weeks ago my friend Frank de Jonge told me he managed to improve an import into a MySQL server down from more than 10 hours to 16 minutes. According to him it had to do with several field types (too long fields to really small data), the amount of indexes, and constraints on the tables. We were talking about 1 million records here. He wondered if it was possible to make it even faster.

The basics

Turns out there are many ways of importing data into a database, it all depends where are you getting the data from and where you want to put it. Let me give you a bit more context: you may want to get data from a legacy application that exports into CSV to your database server or even data from different servers.

If you are pulling data from a MySQL table into another…

View original post 717 more words

Woah! Black Holes in the Movie Interstellar

https://arxiv.org/pdf/1502.03808.pdf