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) OSand 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 :-).
This blog post is recommended for those users who knows about LINUX SERVER & shouldn’t find the meaning of Debian in the dictionary.
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.