Class Enterprise Data Management and Administration

Optimized SQL helps you earn money

This section is an introduction to my article. My goal for this paper is to give managers, web developers, and anyone who works with a database aware of how SQL can affect a web sites load times, affect search engine optimization, and marketing strategies for their company. People generally aren’t aware of how important it is to optimize their queries so that there page will have a good load time. A good load time is generally up to 4 seconds, but with a badly written query it could easily take 10 seconds + if many people are using this website. I help work with people on a daily basis with these problems and it’s unbelievable on how much this will affect marketing for their business.

SQL Causes of slow load times

This section will state specific errors that cause slow load times.

How slow load times can ruin your chances of someone staying on your page.

This section will talk about how people really don’t like a slow website and they will probably leave if it’s taking to long to load.

SQL affects cause a loss of money for your business.

Due to your site being slow and others leaving your page decreases your sales for your website. Since you’re not even getting visitors to your page, you have no chance in converting a sale. With no sale, you may not have a business at some point if all of your business is off of your website.

How to speed up your SQL

This section will talk about how to speed up your SQL queries and website in general to help so visitors don’t leave your website.

How SQL helps your marketing

Every day on websites,