.: Mukul Gupta Profile and Articles
Display by: Popularity | Title
1). Read This Before You Redesign Your Database!As business evolves, the information that they store and process also changes and that means the underlying database structures that have been holding well for many years needs to be changed as well. This are even more complicated when you have redesign an “in use” system.
Here is a step by step guide on what needs to be done:
Step 1: Draw the structure of the new database on Paper Based on the new business requirements, you need to draw the structure of the new database on paper.
2). Difference between Calendar Days and Work Days
Don’t people already know this? Well seems like “Not everybody!”
Both seasoned IT entrepreneurs as well as developers make this common mistake. They don’t seem to quite understand the difference between calendar days and work days. So let me ask you this question – “What should be the delivery date of a project starting on October 1st and having an estimated effort of 160 hours?”
A typical calculation goes like this:
160 hrs / 8 hrs per day = 20 days.
3). Improve the performance of your MySQL Server
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks!
I still hear an awful lot of stories from owners whose databases are running two slow. In my experience, the three main places to look for problems are:
1.