Category: Database


MySQL like any other database has its own pros and cons, you can find them on the web easily, here are a couple Pros & Cons of MySQL Blob’d Images or Pros and Cons of MySQL In this blog I will talk about INNER JOIN vs. IN and LEFT JOIN vs. NOT IN, you can also swap this Read more…


As promised from my previous blog “Converting Data Attribute to Table Attribute Part I”; here is the MySQL code demonstration. First, let us create the two tables and populate them with some data DROP TABLE IF EXISTS users; DROP TABLE IF EXISTS user_attribute; CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, username VARCHAR(128), first_name VARCHAR(255), Read more…


WHAT IS THIS ALL ABOUT? Sometimes there is a need to create dynamic tables or views with variable field structure; In this post, I’m going to explain how to convert data attributes into table attributes; data attributes are values in table field; TABLES STRUCTURE WE HAVE Users table id Username Firstname lastname 1000 Jkhar Jasim Khar 2000 Read more…


I’ll try to explain the situation here as much as I can; we have a .net web app that uses MySQL as the backend database; database size is about 250GB and has 130GB of memory; the app is multi-tenant; one of the app components is a windows services that runs continuously loading data based on newly added Read more…