Tag Archives: tips
mysql tricks: do instant table swap to mitigate mysql deadlock error.
mysql tricks: do instant table swap to mitigate mysql deadlock error. Continue reading
Posted in etl, relational databases, Uncategorized
Tagged database, dba, etl, sql, tips
Leave a comment
basic database table creation and load from csv using mysql and postgres
Basic database table creation with MySql and PostGreSQL. The starting point to most data applications is getting the data feeds and populating the tables. here’s an example of the process I’m loading a stock_history table from yahoo finance api source. … Continue reading
Posted in data wrangling, relational databases
Tagged database, mysql, postgresql, sql, tips
Leave a comment
The Report or Dashbard is taking forever to load
A general rule with BI reports and dashboards is 10 seconds or less for a report or 30 seconds for dashboards. But quite often an analyst will run a report and it never comes back. They’ll say something like so … Continue reading
Data Ninjaeering 