For a big data system, one problem is the data access efficiency, one more problem is that the data insertion is very slow. We had a service system, the data loading process would take 4-5 hours. This time consuming operation is risky since if the program is interrupted during the loading process, it might be rerun, this will be troublesome. So it's necessary to improve the insertion efficiency for big data systems.Here we provide two optimization suggestions.1. Combine multiple insert statementCommon insert statement use is:INSERT INTO `insert_table` (`datetime`, `uid`,&nb...

I wrote a post about how to install MySQL++ and I thought I will write a quick tutorial on how to use it too.This is a very basic MySQL++ program and it’s very self explanatory:#include <mysql++.h>#include <stdlib.h> using namespace std;using namespace mysqlpp; int main() { try { Connection conn(false); conn.connect("DB NAME", "DB HOST probably localhost", "DB USER", "DB PASS"); Query query = conn.query(); } catch (BadQuery er) { // handle any connection or // query errors that may come up cerr << "Error: " << er...