(My)SQL Joins – JOIN, CROSS, INNER, OUTER (LEFT, RIGHT, FULL)


The official logo of the database query MySQL
Image via Wikipedia

It’s been quite some-time since I wrote a blog – sorry guys didn’t get any time to write. But today I got a good one, a place where you find info about sqljoins in a simple/neat explanation.

Today I am going to talk about SQL Joins yes, there are quite a bit of types: Join, Inner JoinCross Join, Outer Join (OUTER Join further divides into Left Join, Right Join and Full Join). Continue reading “(My)SQL Joins – JOIN, CROSS, INNER, OUTER (LEFT, RIGHT, FULL)”

(My)SQL Joins – JOIN, CROSS, INNER, OUTER (LEFT, RIGHT, FULL)

INSTALL (SETUP) DEBIAN Linux OS for Development/Production – A Day with SETUP


Debian OpenLogo
Image via Wikipedia

Today I am going to talk about only installation of tools/apps required for LINUX Server. I have chosen DEBIAN, since it makes you intelligent ;-).

Okay, cool, now? First thing you have to buy a hosting space, there are quite a good people who provide this service – do a quick Google.

OKAY – Now let’s say you have got the hosting space and you have selected the DEBIAN (LENNY) OS and logged into the machine – remember DEBIAN is for intelligent & its not for human-beings means most of the tools/apps will require a separate installation. You have to dive deeper to figure out the tools you want and install them – this is interesting because it let’s you know things :-).

P.S:
This blog post is recommended for those users who knows about LINUX SERVER & shouldn’t find the meaning of Debian in the dictionary.

Let’s get the server ready……

Continue reading “INSTALL (SETUP) DEBIAN Linux OS for Development/Production – A Day with SETUP”

INSTALL (SETUP) DEBIAN Linux OS for Development/Production – A Day with SETUP

MySQL Unsigned INT to Signed INT – A Valid Performance For Index


MySQL
MySQL (Photo credit: Wikipedia)

You know by making an INT type unsigned you achieve 50% improvement in your select query – can’t believe it? Yes, so do I until I tried the tip by myself.

Today I am going to talk about a simple tip on MySQL – create-tables which will improve the performance of the SELECT SQL query.

Let us consider the following table structure:

CREATE TABLE customer
(
id INT(3),
first_name CHAR(20),
last_name CHAR(20),
quantity INT(50),
amount INT(50),
zipcode INT(25),
birth_date DATETIME
)
This is the simple “create table” example isn’t? This table can hold millions of data (record) no doubt on that. But can you give me a guarantee on the performance – when I request some portion of data for a range of field ‘id’? You might say why don’t you add an “index” to the fields. Yes, exactly that will improve the performance of this table, it does increase, and by optimizing this field by assigning the ‘id‘ field an unsigned it doubles the speed of returning (with or without index and performance depends on the number of records you fetch) the results of a select query.
MySQL Unsigned INT to Signed INT – A Valid Performance For Index