Awesome list of FREE tools Startups should be using
This is a curated list of free tools for everything from productivity to hosting to development tools to designing. These tools are all digital i.e., […]
Search Results for: performance
What Things To Keep In Mind When Choosing a Theme
When it comes to choosing a theme for their websites, most newcomers are overwhelmed. There are thousands of themes available, both free and paid. Each […]
One reason why you should refactor your code often
Once upon a time, a consultant made a visit to a development project. The consultant looked at some of the code that had been written; […]
The Quick Selection Tool In Photoshop for Auto Selection
First introduced in Photoshop CS3, the Quick Selection Tool is somewhat similar to the Magic Wand in that it also selects pixels based on tone […]
MySQL Installation and Configuration
A step by step guide on how to install and configure MySQL on the Windows Operating System.
MySQL Query Cache
MySQL query cache is good to cache select queries and their results and improve some performance of your database applications. So, enable query cache in just one step.
Breaking problem into code
Improve the performance of your application by implementing correct logic for a particular problem.
Database indexes and locks
It is important to create good indexes so that your queries do not unnecessarily need to scan many rows, that can result in lock on those rows and due to which deadlocks can occur, performance can be degraded, or anything bad can happen.
Many-to-many relationship
When designing an application or database, also consider other scenarios and pros and cons of the approach being adopted, not only one scenario. In other words if one approach is solving your problem then also consider what other problems we can face due to it, and prepare for those as well.
Referential Integrity
Always use referential integrity constraints. There is no reason for not using it.