Web Design Tips and Tricks

Website Design Considerations

Get Web Design Tips and Tricks on mps-web-design.com. Website Design Considerations topic will increase your understanding on Web Design Tips and Tricks. We at mps-web-design.com only provide news, articles, information in Web Design Tips and Tricks. Web Design Tips and Tricks at mps-web-design.com provides the most up to date news and articles. If you have questions please do not hesitate to contact us.

Q: Should I build and maintain my business Web site myself or pay someone else to do the work for me? -- Wesley L.

A: When you say, pay someone else to do the work for you, Wesley, I am going to assume that you are talking about hiring a professional Web site designer to do the work and not your next-door neighbor's teenage son. If my assumption is correct, then read on. If not, go ahead and surf on over to Dilbert.com. You will get no good out of the advice I'm about to give, so you might as well consult Dilbert for your hot business tips.

Should you build and maintain your business Web site yourself or pay someone to do it for you? Let me answer your question with a couple of my own. Number one: is building and maintaining Web sites the key focus of your business? Number two: could your time be better spent doing more important things like, oh I don't know, say running your business? If your answers were no and yes, respectively, then you have no business building and maintain a Web site.

Remember this: every minute you spend on tasks that are not related to the key focus of your business is time spent to the detriment of your business. In other words, every minute you spend focusing on tasks that do not contribute to the growth of your business and thereby increase your bottom line is time wasted.

If you want to be a web designer, be a web designer. However, if the key focus of your business is building widgets, it doesn't take a rocket scientist to figure out that your time would be better spent building widgets, not Web sites.

Case in point: I once had a very wealthy dentist ask if I could teach him how to maintain his Web site so he wouldn't have to pay me to do it. Now my teeth had helped put this guy's kids through college, but that didn't seem to matter. At that moment he was more concerned about having to pay for changes to his Web site than my personal oral hygiene. Sure, I said, I'll be glad to teach you how to update your Web site, just as soon as you teach me how to clean my own teeth so I don't have to pay you to do it. He got the point. And he charged me enough for the cleaning to keep his site updated for months. Smart man.

Many business owners think they can't afford a professionally designed Web site and that simply is not true. While the old adage, "you get what you pay for" is never more true than when applied to Web site design, having a professional web designer do the work for you is money well spent. A well-designed Web site can bring you a many-fold return on your investment. You can't say that about too many other collaterals. While it is best to leave Web site design and maintenance to the experts, it is up to you (or someone considered a subject matter expert within our company) to provide the designer with the content (text and photographs) that best conveys your company's message to your customers. A Web site, no matter how well designed, is meaningless if it lacks the content required to interest customers in the products you sell or services you provide.

Here's are a few questions that, once answered, will help ensure that your Web site's message is as appealing as its design. Go over these points with the designer before the design process begins as the answers will help determine the direction your Web site's design should take.

What Is The Purpose Of Your Web Site? Most business Web sites have two purposes: (1) to educate the consumer and, (2) to sell them products or services. If you sell shoes, for example, the purpose of your Web site is to educate potential customers on the quality and durability of your shoes and as a result, to sell them shoes. If you paint houses the purpose of your Web site is to educate home owners on why your services are superior to other painters and sell them on hiring you to paint their house. By defining the purpose of your Web site you will give the designer the information required to create a Web site that best conveys that purpose to your target audience.

Who Is My Target Audience? Your target audience consists of those folks you want to attract to your Web site: potential and current customers, future and current employees, possible investors, etc. Anyone who might be interested in your company and its products or services is a member of your target audience. Correctly identifying your target audience is vital since your Web site should be designed specifically to appeal to your target audience.

Put yourself in their shoes (or in front of their computers). Imagine your Web site through their eyes. If you were visiting a Web site such as yours what would you expect to find and what would you be disappointed not to find? Identify your target audience, then have your Web site designed to fulfill their needs and surpass their xpectations.

What Content Should My Web Site Feature? Your Web site content should be driven by the nature of your business. If you're a real estate agent, your site should feature photographs of homes you have for sale and information on buying and selling a home. If you own an auto body shop, your site might feature before and after photographs of cars that you have repaired. Remember to determine the purpose of your site, then develop the content to serve that purpose.

What's My Competition Doing? The last question you should ask is one of the most important: What is your competition doing on the Web? Do a Google search for similar businesses and click around their Web sites. How are their Web sites designed? What message are they trying to convey? Are they doing a good job of conveying that message and as a result, selling products? What do you like about their Web sites? What don't you like? Make note of the things you like and the things you hate, then share your findings with your site designer.

Remember, you're not stealing trade secrets here.

You're just borrowing ideas.

Here's to your success.

Tim Knox

Some simple suggestions

Well I don't consider myself an expert, I do have experience with working with larger datasets and there are a couple of things that I always do to keep queries performing well.

Optimize Queries with EXPLAIN

Explain is your friend, get to know it well. If you take the time to read thru the Explain documentation on the MySQL site, you will find some valuable information, some of which is hilighted below.

Optimizing joins

Single sweep what?

MySQL resolves all joins using a single-sweep multi-join method. This means that MySQL reads a row from the first table, and then finds a matching row in the second table, the third table, and so on. When all tables are processed, MySQL outputs the selected columns and backtracks through the table list until a table is found for which there are more matching rows. The next row is read from this table and the process continues with the next table.

Why is this important? Imagine a main table - tableA - with 80,000 rows of data. This table has a corresponding n:n table that maps entries in tableA with a locations table. A query could be written as:

SELECT tableA.*, locations.location from tableA 
Left Join tableA2locations on 
tableA2locations.tableA_id = tableA.id
Left Join locations on 
tableA2locations.location_id = locations.id
where locations.location = 'sometown'

Keeping the above quote in mind, MySQL will read a row from the first table and join the corresponding data from the joined tables for that row and then sweep thru the rest of the data, joining as it goes along.

This leads us into the following section.

Number of rows needed to execute a query

You can get a good indication of how good a join is by taking the product of the values in the rows column of the EXPLAIN output. This should tell you roughly how many rows MySQL must examine to execute the query.

From the above, you can determine that for a query on tables that have not been properly indexed, a join can quickly become unwieldy when dealing simply with three tables with records in the thousands (1000*1000*1000 = a slow query). See HackMySQL for a good example of this.

Reducing the number of rows needed to execute a query

So beyond indexing properly for joins, you can still end up with a query that runs in a way that causes a bottleneck.

Taking our example from above, imagine that we use a where clause that limits the tableA selection to half (tableA.foo = 'bar' below):

SELECT tableA.*, locations.location from tableA 
Left Join tableA2locations on 
tableA2locations.tableA_id = tableA.id
Left Join locations on 
tableA2locations.location_id = locations.id
where locations.location = 'sometown' and tableA.foo = 'bar'

This starts us out with 40,000 rows of tableA data to examine. If there are a further 2000 rows from tableA2locations, thats 800,000 rows of data. Not astronomical, but significant. If this was a 3 or 4 table join, things could get ugly. What to do? The answer may be obvious to some: select first with the most limiting table:

SELECT tableA.*, locations.location from locations 
Left Join tableA2locations on 
tableA2locations.location_id = locations.id
Left Join tableA on 
tableA2locations.tableA_id = tableA.id
where locations.location = 'sometown' and tableA.foo = 'bar'

This starts us out with 1 selection from the locations table, then 2000 from tableA2locations. If the join between tableA2locations and tableA is indexed correctly, we are then left with an index join based on ID, rather then having to initially select 40,000 rows from tableA as in the previous example.

When I first started programming, it made sense to me to select from the main table (tableA) and join the lookups. But once you add some data to the mix and start to play with Explain, you quickly realize that selecting from the limiting table can make your server's life a little easier.

For further reading on the topic, I always send people to HackMySQL when they ask, so for more tips and tricks, be sure to have a read thru the optimize section of that site.

More Articles: