Attacking wifi tools and how attacks work.
Wifi types are open, wep, wpa1, WPA2, wpa2 enterprise. There are also services on wifi to help people connect for the first time easier.  This service is called wps.  WPS is either active or passive. So here are the bellow 


And here is the explanation for the different wifi types of connections and attacks and security against them.


Open:

There are open wifi networks are just that open to everyone. There is not much to do here than connect.
  
Wep:

Wired Equivalent Privacy is the first encryption type for wifi. It's not meant to be the most secure but better than nothing. There is an vulnerability in wep protocol is a vulnerability in the rc4 cipher stream. the Fluhrer, martin, and Shamir attack (FMS) is a n attack to recover the key in large number of message streams. This attack is in the weak initialization vectors on the rc4 for wep. by gathering a lot of IVs around 50k you should be able to easily get the key. Read more about the actual attack and the link above. 
These attacks are easy to implement in various tools like aircrack or scripts that automate the attack for you like wifite orwepcrackgui
So the attack goes like this generally speaking. attacker puts card in monitor mode with something like airmon-ng, then once in monitor mode the card can pick up packets across the air even if it is not connected to that network (see monitor mode). From there attacker picks a channel of his target and begins his attack. After capturing IV packets by either deauthenticatingthe client, doing a replay attack, or some other attack the attacker tries to then use a FMS attack against the IVs and get the key.
For another simple explanation of the WEP attack can be found here.  


WPA1:

wifi protected access is leaps and bounds ahead of WEP though still has some issues with it. weak keys, wpa packet spoofing and decryption. with WPA there are attacks against the WPA-TKIP allowing decrypt packets and then inject the packets to hijeck connections. 
you can read more about the actual attacks at the bellow links
https://lirias.kuleuven.be/bitstream/123456789/401042/1/wpatkip.pdf
http://dl.aircrack-ng.org/breakingwepandwpa.pdf
http://download.aircrack-ng.org/wiki-files/doc/enhanced_tkip_michael.pdf

there are 2 basic encryption protocols with WPA CCMP and TKIP. most the attacks above use the TKIP. the if the nettwork is using CCMP then its using the AES cipher which is a lot stronger. 
Though other attacks against WPA personal (WPA1-PSK) is to run either a dictionary attack against the handshake or if the SSID is a common SSID to use a rainbow table. Rainbow tables are generally not used because the way WPA works is that it stalts the password hashes with the SSID of the wifi network. This means that 2 networks with 2 different SSIDs and the same passwords would have 2 different pairwise master keys PMKs. So less you have a user with a simple dictionary word or a common ssid name brute forcing is generally not the best option out there. Though this does not mean its not possible if you take into human habit and the standard into account. the WPA-PSK requires the passphrase to be 8-63 characters long. Knowing this fact and the fact that humans want to try the least possible they most likely will use a word starting and being only 8 digits long aka the minimum length required. This allows an attacker to create mask attacks against the wpa keys in hoping that the human element is what created the weakness. Since a mask attack does not require brute forcing 1-7 digits it starts at only trying the 8 digits and then on top of that starting with trying only say the first 4 characters of the password be letter and then ending with numbers or symbols you can reduce the attack brute force dramatically in time making a brute force with a GPU possible. here is a benchmark on how fast a single GPU can run for pyrit HERE. So if you combine a lot of GPUs together like the amazon cloud or just creating your own farm or botnet. then cracking a WPA is a lot faster than expected. 
you can find out more about the WPA1 standard at the bellow link 

https://en.wikipedia.org/wiki/IEEE_802.11

WPA2 Personal (aka WPA2-PSK):

along with the mention above with WPA the WPA2 protofal was built to fix shortcomings in the authentication and privacy of WPA1. i wont go over a lot of the information again about the attacks. Though WPA2 in general has less flaws in it than WPA though the attack vectors are still the same. 

WPA Enterprise:

WPA-Enterprise is the use of a RADIUS or a TACACS+ server to authenticate connections on the network. The only major flaw found in it is the MS-CHAPv2 which severely reduces the complexity of brute-force attacks. Check out the bellow link for more information on the attack. https://www.cloudcracker.com/blog/2012/07/29/cracking-ms-chap-v2/

WPS:

Wps as a protocol to help non technical users to easily setup wifi networks where they wouldn’t have to type out complex passwords but only push a button and connect. you can find out more about WPS at the bellow link 
https://en.wikipedia.org/wiki/Wi-Fi_Protected_Setup
with the WPS attack by reaver was originally explained here and explained here and then was later developed and improved upon by wiire with the pixie dust attack and can find the code for it here pixiewps . 
A more updated toolset is located at the next 2 links for reaver and pixiewps 

since there is a huge amount of resource for information on both the links above i won’t go into the attacks much or how they are done. 


To sum all this up the easiest attack is against WEP or WPS depending on the encryption used and if one is implemented. Though if neither of these are used or turned off then using another attack method is generally used or the attack is given up on. the attacker could try to brute force the pin hoping the human created it insecurely or what is not commonly though of is doing a evil AP attack on the client. This attack would de-authenticate the client from the valid SSID and then if they connected to a open network like starbucks wifi or attwifi etc. you can create a SSID with that name and most systems will automatically connect once they are connected to your system and passing their network packets through your machine you can then inject code into the trp connections and gain access to their computer. Once in their computer you have the ability to dump the wifi authentication credentials. When an attacker attacks wifi its not always the wifi protocol that they attack. I hope this helps you learn how its done. so to close it all off… i will show you the easy automated way of doing it from your android phone… yep android.
Do you remember asking your friend with a Camera on a Trip to share the photographs with you? Or do you remember asking your photographer friends to tag you in the photographs while they upload them on facebook? Well, there’s a good news for you if you did so.
Facebook has launched a standalone app for sharing the photographs among friends. The launch was reported on official facebook newsroom by Will Ruben(Product Manager).
Moments syncs your photographs with all the people who are in those photographs. Moments groups the photos on your phone based on when they were taken and, using facial recognition technology, which friends are in them. You can then privately sync those photos quickly and easily with specific friends, and they can choose to sync their photos with you as well. So, you have all the photos that you are in.
Moments also keeps all of your synced photos organized and even lets you search them to find the ones that you or specific friends are in. Moments uses facial recognition technology to group your photos based on the friends who are in them. According to Facebook, this is the same technology that powers tag suggestions on Facebook.

"If executives at Google had decided to study the things we’re studying, they could easily have been flipping elections to their liking with no one having any idea- Robert Epstein"

ou just know what you are told. The statement holds true in most of the aspects where you get the second-hand information from the media, or the so-called ‘reliable sources’. There is no doubt in saying how big role does media play in any democracy and elections. Also, the electronic as well as social media is crucial in deciding the party’s future.
Google, for instance, with its search results can change your opinion about the presidential candidate for the next elections. If you Google search about any party candidate, the top stories which could be either positive or negative can have a huge impact on the way you vote. So, when the time comes, websites such as Facebook and Google can influence presidential elections in your country.
According to Robert Epstein, a psychologist at the American Institute for Behavioral Research and Technology and his team coined the term Vote Manipulation Power (VMP) and said:
Based on the win margins in national elections around the world, Google could determine the outcome of upwards of 25 percent of all national elections.
Robert’s team surveyed India’s Lok Sabha elections and were amazed seeing the intensive election environment in the country. The voters, in general, got heavily exposed to the information by the social media. The team surveyed the undecided voters and gave them the information from the Google results, and the VMP scores were off the charts.
Also Read: Google: NO Need of Global ‘Right To Be Forgotten’
If you are a working class professional, there are chances that most of the information regarding the parties and their candidates would come through the Google search or the news feed from the social media websites or from your regional groups.
Influencing Google’s search algorithm is not easy, but not impossible either. Whatever, the results you see, come from the upvotes and the ‘reach of the news’. So, if you are not from any political wing, or a hardcore supporter of any party, the Google results will have a definite impact while you vote, and become the key factor as Google influences elections.
During the 2010 US congressional elections, 61 million people were called upon to vote for anyone of their liking by Facebook. It was later found that 340,000 extra votes were generated as an effect.
It is not possible for Google or Facebook to completely maintain a neutral algorithm during the election process. If not the parties, then the supporters try to influence on the social media platform.
With the Google search rankings, the general public can easily be maneuvered and the election results tweaked. So, collect information from all the sources and get to a common conclusion, before believing just one source, because now you know, how your favorite search engine Google influence elections in your country.









Are you selling products online? There are many small objects that designers and developers must keep in mind to transform visitors into Happy visitors and repeat customers. Today we will discuss some exceptional features that every e-commerce store must have.
5 tips to drive more customers to your online store
Nobody has time to visit retail store for shopping. Everybody loves to shop online. That is the reason why the eCommerce industry is booming in current digital era. And why not? It is more convenient, easy, fast and time saving option to shop online. That naturally increases the competition among the online store owners. Today we are going to discuss how you can standout the best among the competition by some exceptional features of an eCommerce website. If you are selling any product online and seeking for conversion, you must make sure your site has all these features. These features not only make your store technically solid, but also keep your website a preferred place to shop for online buyers. 
Make website accessible from all devices 
According to the latest eCommerce trends, one out of every three online purchase are happening via mobile devices. This shows how it is important to have a responsive design that provides the optimum buying experience on any device. It is also advisable to connect your e-commerce store with a mobile application that makes it even convenient for mobile users to reach you. As search engine giant like Google is also giving higher priority to responsive websites. Having a responsive design is not only important, but it is a necessity of the digital shopping area. It doesn’t end by making your website responsive. You must have a website that visitors think as their own place to shop. Customer should fall in love with your website. Your website must have simple navigation, clean architecture and high quality product images to offer happier purchasing experience from every device to each user.

User experience is the key
How online users feel while accessing your e-commerce store or an application is the key factor that defines the success of the business. Apart from responsive design there are lots of other factors that you must consider to make your website user friendly. A website must load faster. Nobody likes to wait while  page is loading. They will simply leave and approach your competitor. Website navigation should be easy and clear. The user must know where they are (on category pages or sub-category page or product page or in checkout process, etc.) when they land on any page of the website. The precisely designed product page is must. Nobody will like to purchase from the page where they won’t find ample information about the product in an appealing manner.  Shopping cart design is also an important element of an eCommerce website. Shopping cart must clearly display order information, its layout should be simple and it must contain prominent checkout buttons.
Keep it search engine friendly 
What if your potential customers can’t find you online even if you have brilliantly designed website that offers the elite user experience? According to the trends, 94% of the Google searches end up into organic clicks. It means if your website is not properly optimized for search engines, you are missing out a lot. Clean URL structure, Better navigation, easygoing product classification, fresh and unique content, strategic keyword targeting are some of the major tactics that you must consider to make website search engine friendly. Google loves fresh content that provides unique value to visitors. So it is very important to keep website updated with original and fresh content. Backlinks are not dead yet. You must try to earn some quality backlinks to support other optimization. But before all these, it is most essential to check that your website is technically correct and properly optimized.
Power of  Social Media 
Social media can work as helping hands for your brand when someone looks to purchase product from your store. You can utilize the splendid power of social media to build the brand and community for your business. Social media helps you to know what people are thinking about your brand. You can directly communicate with your followers through different social media platforms. It lets you share information among the community and take their reviews too. You can deliver better, if you know the expectations of the community. That is where social media comes into the picture. It provides the evidence of the customer expectations. Social Media Marketing doesn’t always about promoting your product. But it is all about developing relationship and spreading love among the community. You can utilize hundreds of social media platforms available online like Facebook, Twitter, LinkedIn, GooglePlus, Instagram etc. to get in touch with your targeted audience.

Short and secure checkout process 
Checkout process is what defines the overall user experience of the website. Customers don’t like lengthy and confusing checkout process. Web security and payment privacy is also the area of concern for the online buyers. Almost 25% of the purchase doesn’t get completed due to web security and privacy reasons. It is essential to make the process secure. Checkout process taking customers from one page to another is very annoying. Ideally, purchase process should be as simple as you shop in retail stores; “You pick the product, make payment and live happily”. It is not always possible to have such process for e-commerce store, as it requires some additional information like payment preference, email information and shipping address, etc. But you can definitely make it simple and understandable if you properly design the checkout process. The single page checkout process can help you achieve your target without troubling customers.
These are five major factors that build the successful e-commerce store. There are lots of other factors like frequency of product updates, in-site search, product comparison, payment options you provide, customer support, product suggestion, shipping options etc. that make a successful e-commerce store. But the crucial element that makes your store successful is how users experience purchasing from your store. If users will like the experience they will defiantly come back and recommend your store too. So, e-commerce website that offers the optimum user-experience considering the offered product is the key to generate maximum revenue through the online store.
PHP is one of the most admired and popular server side scripting languages which are widely used for creating websites. With faster turn-around time, enhanced security and affordability, PHP has become preferred choice of the website developers. Due to plethora of benefits of this scripting language, many famous online businesses such as Facebook, Yahoo, Wikipedia, Flickr etc. are using this scripting language. In this article, I am explaining 11 advantages that make PHP popular among web developers.

Reason #1 — PHP boasts Simplicity

With PHP, coding is like writing an essay in English for a computer to read, except the essay is a piece of code that instructs it to create and run websites in the most efficient manner possible. Creating a code in PHP is simple, and though you’ll hear some developers complaining that this does not build the necessary coding habits that streamlines (read standardizes) coding, it allows the code to be highly personalized (and hence easier to protect).

Reason #2 — PHP Is FREE

PHP is an open source language: free, is easy to use, and has a stupendous amount of available documentation — making it the most cost-effective method of creating robust websites and taking over online real estate space without worrying about legal obligations and subscriptions fees.
Furthermore, PHP reduces barriers to entry for new website developers, allowing them to simply leverage their skills and talents for coding to get started.

Reason #3 — PHP Works Exceptionally Well With CMS

The latest (and recent) trend towards adaptive content has made CMS customization a crucial competitive need for businesses. Adaptive content is content personalized for the individual visitor to the website (using sign-in, or visitor history) to create a one-to-one experience for visitors. This is only possible if the website’s code can be customized and integrated with the CMS.
PHP makes websites amoebic, allowing the developers to transform them at their will. All PHP websites are fully customizable and can be transformed to meet the requirements of the customers with ease because Content Management Systems like WordPress, Drupal, Joomla and others are primarily based on PHP. Hence, developing or integrating a robust custom-made CMS solution with your website is simple.

Reason #4 — PHP Accepts Platform Diversity

A code created in PHP can run on all the major platforms, allowing the developer to seamlessly integrate website across multiple platforms. This allows the business to cost-effectively leverage all existing infrastructure, leveraging platforms as diverse as Windows, Unix, and Linux, with the additional ability to interface their website with MySQL and Apace.

Reason #5 — PHP is Powerful Flexible and Scalable

Facebook, the largest and most powerful social media platform is running on PHP. Facebook has even created a PHP derivative language, named “Hack” to meet the emerging needs of the giant’s content management needs. This shows the level of flexibility, robustness, and scalability that is built into PHP. Compared to other languages, PHP’s biggest advantage is that the website’s code can be updated without requiring a server reboot!

Reason # 6 —Extensions and Add-Ons

PHP is one of the most scalable languages for website development. Being an opens source language, its family of online developers is continuously involved in developing extension to meet the emerging requirements of the businesses. This allows the developers and businesses to easily develop and add newer functionalities and features to their website with ease.

Reason #7 —Embed-ability

The latest trend in adaptive content has made responsive website and fluid grid systems even more pertinent to businesses. In this context, HTML5 is the unquestioned industry standard for developing highly dynamic and responsive websites. This is where PHP surfaces as the language that allows its code to be easily embedded into the HTML. Developers can easily convert existing static website code into a whole new dynamic one by adding their PHP code into HTML.

Reason # 8 —PHP is Backed By a Vast Community

This is a corollary of PHP being open source language. The language itself has a vast and growing community of developers and professional experts willing to support beginners and involved in continuously addressing the latest problems facing the web developing community. Furthermore the popularity of the language and hence availability of developers means that the developers are bound to offer highly competitive pricing.

Reason # 9 — PHP has a Huge Standard Library

What differentiates a good programming language from a great one is the extent of its standard library. Libraries play a crucial role in simplifying and speeding the data processing ability of the language.
Given that online visitors spend no-more than 8 seconds per webpage while they are on a surfing spree (in the earlier ‘research’ phase of the buying process), website’s loading time plays a crucial role in keeping them engaged on the website. PHP offers extensive support for HTTP fetching, regular expressions, URL parsing, and database drivers, to name but a few. It is true that the library is incoherent, but the community’s on it!

Reason # 10 PHP Delivers Exceptional Performance

PHP improves speed of development as much as it improves speed of execution. Operating on a conventional web stack, PHP leverages the Apache web server and allows applications to leverage MySQL databases — allowing developers to create bespoke, one-stop solutions for online presence.
Turnaround time is one of the most important factors that enhance performance of any website. PHP is known for its quick turnaround time. The large standard library, a diverse range of extensions, cross platform functionality, seamless integration with and customization of various CMS, and embed-ability allows experienced developers to offer exceptionally fast turnaround times at highly competitive rates. Further, any website that is developed using PHP has faster data processing features and that website is compatible on all operating system such as Windows, UNIX and so forth.

Reason #11 — PHP offers Diverse Frameworks


PHP is able to deliver exceptionally fast turnaround times because it has a sufficiently large family of PHP-frameworks. These range from the enterprise level Zend and Yii frameworks, all rounder Laravel and Sympfony, performance optimizers like Phalcon, and PHPixie for speedy application designs or Code igniter for more robust ones.
Now a day's, most people from teenager to middle age are buying smartphones which includes good quality cameras. As the social networking websites like facebook, twitter etc. grew and we became used to it, the use of photo have increased a lot. People now shoot almost anything they do all day around.

But some of us don't just want to shoot a photo, we want to to shoot it well. May be we can't afford a DSLR but we want to keep enjoying our love for photography with the mobile camera that we have. The following tips are for those. More tips will be added with detail instructions in the next part of this series. 

1. Carefully Clean The Lens: 
     A clean camera lens is a must for a clean photo. When we hold the phone, we leave our fingerprints on the lens of the camera at back. So to get started with mobile photography, first we should clean our mobile camera lens. Clean it with soft, clean piece of cloth and if you see dust inside the frame your mobile phone, then open it and clean from inside also.

2. Work with focus:
     Now with mostly every camera app in your smartphone, you can control the focus. Though sometimes it doesn't work, but it works most of the time. Focus will give your viewers a pin-point direction on what to see in the photo.

Morningtone.com Mobile Photography

3. Get close to the object:
     While shooting photo of a product or small thing, get close to the object as much as possible. This will make it better unless you have a different idea in mind.

C360_2015-05-20-02-44-53-701

4. Do not zoom:
     With virtual zoom of your mobile camera you will never be satisfied. So it is suggested that you never zoom, rather you can crop the image later to keep the only thing you wanted.

5. Keep the camera steady:
     Mobile camera will not work like a cybershot camera, it takes time to capture the image. So don't shake your hand or move camera to something else right after clicking. Instead, wait until it says that the photo has been saved.

6. Shoot more than one photo:
     Try to shoot more than one photo, this will ensure that one of the photos will look better. After all, who don't want some options to choose from, right? So try to shoot 3-4 shots of a single view, so that you can later find the best one.

7. Shoot from different angle:
     If you are not in a hurry or things are not happening very fast, try to shoot one view from several angles. At the end of the day, you can find the best one comparing all of them.

8. Ignore camera app filters:
     From my experience I found that it is better to edit the photo later in computer with photo editing software is better than using a built-in mobile camera app filter while shooting the photo. May be because, photo editing software in computer can perform well than mobile camera apps on your mobile.

9. Try to learn about photography terms:
     Terms like exposure, ISO etc. plays important role in photography. Try to study these terms online and experiment with them. This will open new doors for your mobile photography fantasy.

10. Experiment, Experiment & Experiment:
     There's nothing better than experimenting yourself. So don't wait, turn on your mobile camera and start shooting things around you. Play with your tools of your favorite camera app. 

I was in a hurry while writing post, I will surely come up with the next part very soon.

Let me know your experiences with mobile photography in the comments.

Clean code, Happy code.

Coding for nearly 6+ years, I can tell you from my experience, clean code is a must. Not a matter what you code, from a tiny program of 15 lines to huge one including thousands of lines, practicing clean code is necessary.

As a coder, you may think why you have to write clean code while you are just practicing. Well you answered your question. PRACTICE, which makes a man perfect. However, following are tips for coders today

1. Indentation: First rule of clean code for me, indentation. If your code is not properly indented, it is a mess for sure. Not only the other guy but also you will not recognize your code after completing another project. So it is a best practice to use proper indentation.

2. Naming Convention: One of the best practices for coding is using a static naming convention for functions, classes, variables, constants etc. Even file names should follow a convention. A good naming convention which is static for all the members team can help other easily understand what a variable for function name means. It should be used properly, and at least should not change in the middle of a project.

3. Commenting (Necessary Commenting): Commenting is another best practices for clean code. But keep in mind, unnecessary commenting will only increase lines and will make the code's readability harder.

4. Distinct convention for special words: Best practices include special words to be highlighted in a different way. For example, naming the constants with uppercase letters, naming the global variable with a preceding underscore (_) like $_system, uppercase letter for SQL query special words etc.

5. Documentation: It is quite like commenting but it has its own rules. Try to study open source code to understand how to write documentations for functions, class properties etc. So that reading those documentations you and other can easily understand what is the use of this properties, what are the parameters of this function, which parameters are required and which has default value. Well documentation is highly required in projects where multiple people are working where one user may use code written by another user.

These are only a few tips. As a coder you should find out good coding / coding standards and practice them even for a single line of code. Another post with more tips will arrive soon.

Happy Coding.
Millions or may be billions of websites and pages of those websites are out there. To make mark of your own website or to get recognized by the search engine, SEO or Search Engine Optimization is a must. SEO techniques includes a lot, but I will be starting this series post with only 5 best SEO practices.

1. Title of the Content: Title of a content is very important for SEO optimization. The title is also important as because this is what readers read before reading your full content. This has to be attractive and interest grower. Using questions in title, numbers before title helps getting attraction. Learn more about content title here.

2. Keywords: One of the best practices for SEO is to find and use relative keywords accordingly throughout the content. You can researching for keywords using different tools that I will discuss later and use them wisely in your content.

3. Meta Tags: Meta tags are like short introductory of a web page. Best SEO practices includes the use of meta tags for each page uniquely. Meta keywords and Meta description both are important. You should keep your chosen keywords in the meta description.

4. Inter-Linking your contents: Another best practices for SEO is inter-linking similar type of contents. For example you wrote about 5 different cars in 5 different posts. Then you wrote summery post where mention all 5 of them. Link those 5 posts from that summery post. This helps search engines to find relative contents. And also help your reader read more content and stay more time on your site.

5. Keep the content unique: Content is king. Better content, better readers. Remember, google (even other SE) can easily track down duplicate contents. Yes, obviously you need to learn more about topics that you are about to write, but just don't copy them blindly. Instead gather information and write your own ideas.

Thanks for reading.
The market of website design and development is growing with a fast pace. In order to promote and advertise an organization, firm or business, people are taking help of website designing. This represent the type of business under taken by the owner on the world of Internet. Internet has flooded with billions of websites offering and dealing with numbers of goods and services. We have such organizations that are in the field of web designing and its development. They offers with building up of such websites that are helpful in earning huge profit in the business. These web designing companies are capable enough in delivering the best services and enhancing the profit of the firm with the help of their progressive and innovative steps.
Number of points are responsible for the growth of a website likewise the quality content, graphics, images, look and feel etc. A website is made attractive with the use of these most important features. This task is generally taken by specialized person in the grounds of website designing and development. Developing websites through big companies is not under everybody’s pocket. Therefore, they opt for local website developers. There are some of the reasons why people prefer for local Web Development Company. They are as follows:
Reasonable Charges– Local web development companies charges with their affordable prices as compared to the US, UA web development Companies for the same project.
Trustworthy– Local developers complete their projects with perfection. They know the value of delivering the project on the due date by meeting the deadlines. Their proficiency can easily be judged from their small and big projects. With all these qualities the company earns a reputation in the market.
Complete internet Solutions– Offers like modern multimedia websites, ecommerce websites, Education websites etc. are given with complete internet solutions company. The development from the preliminary stage to ending stage is done with accuracy.
Technically outstanding– The professionals have sound and deep knowledge of website designing and development. The experts with the help of latest and leading technology create adequate website.
Finished services– The handle over the project to their client with finishes services along after sale services with affordable rates.
Attractive Website not only mark their remarkable presence on internet but also represent an amazing brand image for the business. A website should therefore be created by keeping the opponents in mind with innovative ideas and creativity.

Have you ever optimized a database and felt like the tuning is not working? It could be you are doing one or more of the following database performance tuning techniques.
Here are some 5 well-known database performance tuning myths that it appears, for now, have been debunked.

#5. If the performance sucks, put an index on it

Indexes are great for retrieving data from tables that have a lot of records. They speed up select queries.
But actually…
In the name of Create, Read, Update, and Delete (CRUD), Read or SELECT is only ¼ of the pie. Indexes affect the performance of create, read, and delete. You need to consider the effects of the indexes on create, update and delete operations before you decide to use them.

#4. If it’s slow, just optimize using 101 optimization tips

It is a common practice to rush to optimizing the database if the performance sucks. We have all heard of performance tips so we just have to implement them.
But actually…
What exactly are you optimizing? Have you done profiling to discover what is causing the performance to suck?

#3. Performance tuning should be focused on the database and not application level

Hey Mark, the system is slow. What’s up with that?
Mar: Let me check with the DBA, she probably needs to optimize the database
But actually…
You have code that creates views on the fly and they are not optimized for performance. You are using SELECT * as opposed to SELECT field names. Even when you use field names, you include columns that you do not need etc.
Optimization needs to be considered both at the application and database levels.

#2. You assume HAVING and WHERE are the same.

What is the difference between WHERE and HAVING? HAVING is used when you are dealing with a GROUP BY
But actually…
WHERE filter is used before retrieving the data. HAVING clause returns all the data, applies the filter then returns the results. This makes WHERE clause faster than HAVING.
If you do not have a good reason why you should use WHERE over HAVING then you probably need to use WHERE.

#1. SELECT field1, field2, field3 performs better that SELECT *

Using * when selecting database takes more time because the server needs to figure out the field names.
But actually…
The above is correct but return all the columns using field names still hurts the performance of the database. The key is to use specific field names and only return the relevant columns.
Next PostNewer Posts Previous PostOlder Posts Home