Tryangled Solutions web designing tips tricks

MySQL has two primary storange engines: MyISAM and InnoDB. Each has its own performance characteristics and considerations. In the broadest sense MyISAM is good for read-heavy data and InnoDB is good for write-heavy data, though there are cases where the opposite is true. The biggest gotcha is how the two differ with respect to the COUNT function.

MyISAM keeps an internal cache of table meta-data like the number of rows. This means that, generally, COUNT(*) incurs no additional cost for a well-structured query. InnoDB, however, has no such cache. For a concrete example, let’s say we’re trying to paginate a query. If you have a query SELECT * FROM users LIMIT 5,10, let’s say, running SELECT COUNT(*) FROM users LIMIT 5,10 is essentially free with MyISAM but takes the same amount of time as the first query with InnoDB. MySQL has a SQL_CALC_FOUND_ROWS option which tells InnoDB to calculate the number of rows as it runs the query, which can then be retreived by executing SELECT FOUND_ROWS(). This is very MySQL-specific, but can be necessary in certain situations, particularly if you use InnoDB for its other features (e.g., row-level locking, stored procedures, etc.).

<gmail.com>: Google’s attempt at free e-mail. Instead of the 2-6 MB of free space that Yahoo and Hotmail used to provide, Gmail gives you 2,600 MB (and growing) of space (this has already caused Hotmail and Yahoo to raise their amounts to 250 MB and more; AOL.com now gives you 2,000 MB free). I have been using it for 1.5 years and it’s terrific and fast. One caveat: Google runs small, text-ads on the side of the screen, based on content of your e-mail messages. That’s scary to a lot of people, though Google promises no human will ever see your messages, just those Google servers (remember, however, that all e-mail can potentially be scanned by various systems). I don’t use it as my primary e-mail. I use it in two ways, with two accounts. One is an account to which I send messages, photos, PDFs, I want to save for future access, including big messages that I don’t want taking up space in my regular inbox - kind of a “greatest hits” collection. The other is an account that get a copy of every e-mail message I get, so that it’s all backed up and available in one place.

The HEADING tag is used to display your heading text in a larger font with <H1> being the largest down to <H6> being the smallest.

Some Search Engines place relevance on text displayed within the <H#> tags, so place some of your most relevant keywords within any of the 6 <Hx> tags.

Example:

<H3>Your Guide to Health & Fitness</H3>

When using the HEADING tags, you don’t have to use the <H1> for your first heading. You may begin with the heading size of your choice. However, for your secondary headings, you should not use a larger heading than you began with. In other words, if you’re using <H3> for your primary heading, then your secondary headings should be <H4> or <H5> and not <H1> or <H2>.

Web sites are all the rage today, it seems more companies and professionals have decided they need them and have put plans in place to build a site for their business. Unfortunately outside of the basic notion that a site is needed most businesses don’t plan out what a web site will do for their business. It becomes a situation where you want one because “they” have one, but unfortunately without purpose and planning neither your site nor theirs will be successful.

A statistic regarding web sites is that over 1,500 new web sites are launched every day somewhere. With that many new sites being created every day to make yours stand out, much less provide value it has to have purpose. Here are four steps to creating a stronger web site for your business.

Know your Purpose

Is your web site designed to sell products online, build your prospect list or serve as a vehicle for information fulfillment? It could be one of these things it could be a combination of them. However even if it has more then one purpose then answer the question what is the primary purpose of the site? Rank your priorities in order of importance from first to last. Once you know the purpose you can focus the site on achieving this goal.

Build Your Site Around the Primary Purpose

Build your web site around your purpose. For example, if you goal is to build a site that grows your prospect list then you need to focus on creating ways to get visitors to give you their contact information. You could do this through an online newsletter, free reports, giving away products or consultations and other methods of giving value to a user that will trade that value for their contact information. Your site navigation, color, overall design, copy and organization needs to be built around achieving this goal.

Offer value

If your web site is a basic brochure about you or your company that ranks very low in terms of providing true value to a visitor. If you can offer articles, free reports, fresh updated content, checklists, links to other sources, a current blog on your expertise, etc. you give people a reason to explore the site and share it with others. You also create a reason for the visitor to come back to your site and expose them to your message and marketing again. If you don’t offer value and instead just have a site all about you and your company you may get visitors once, but soon your traffic will start declining. You want to create a site that is vibrant, alive and a destination for visitors, one that they will willingly come back to. The key to getting this interaction with your visitors is value, offer it and they will come.

Measure progress

Once you have something of value to offer now you need to measure how successful it is. However measurement of useless information isn’t going to help. Figure out what really constitutes a useful measurement. Is it sales, visitors or names for your list? Whatever “it” is be sure you not only know and measure it, but have the goal in mind of what this measurement needs to be to constitute success. There are several great management tools that can give you web statistics on your site, but without the right stats and goals that information is about as useful as ice in Antarctica.

It is too easy to build a web site today, so easy that most become a failure. Don’t let your site become a failure because of lack of purpose and planning. Know why you need it and what the goals and plans are to achieve the “why” then like any good plan execute it and measure your progress. If you apply this strategy your site and business will be much more successful.

Keyword in links have more importance than simple text.

Use your primary and secondary keywords in the anchor text of links when linking to other blog posts or to other pages on your main site.

Link keywords where they naturally appear in the body text, but again, don’t overdo it, or you’ll end up with spammy looking pages.

If your primary key phrase is “business blogging” make sure that the word business, or blogging, or both, appear in your blog headers (the H1 or H2 tags) as well as the title of each of your posts.

Most blogging software will take the keywords in your post title and put them into the file name of the permalink posts it creates.

For example, if you have a blog on Blogger and title your post “Search Engine Optimization For Blogs”, Blogger will automatically create a page with your post and name the file “search-engine-optimization-for-blogs.html” or something similar.

With other server-side software like Wordpress and Movable Type, you may require the mod_rewrite command to save the title of your entries as a permalink.

Whether you purchase a separate domain (recommended) for your blog, or host it on a blogging service or a subdomain of your own site, try to ensure that your URL contains the primary keyword you want to optimize for.

For example, if you want your blog to get found for the keyword “rss” get a domain with the keyword “rss”, or use the keyword in a subdomain as in

http://ebizwhiz-publishing.com/rssnews

Getting a domain name with your own name might make for good branding, especially if yours is a personal blog.

But if you’re doing it for business and want the targeted traffic to flow your way, keywords in the domain or subdomain are a move in the right direction.

Hosting your blog on a different domain from your primary site is one of the worst mistakes you can make. A blog on your domain can attract links, attention, publicity, trust and search rankings - by keeping the blog on a separate domain, you shoot yourself in the foot. From worst to best, your options are - Hosted (on a solution like Blogspot or Wordpress), on a unique domain (at least you can 301 it in the future), on a subdomain (these can be treated as unique from the primary domain by the engines) and as a sub-section of the primary domain (in a subfolder or page - this is the best solution).