Tryangled Solutions web designing tips tricks

MySQL supports various of table types or storage engines to allow you to optimize your database. The table types are available in MySQL are:

* ISAM
* MyISAM
* InnoDB
* BerkeleyDB (BDB)
* MERGE
* HEAP

The most important feature to make all the table types above distinction is transaction-safe or not. Only InnoDB and BDB tables are transaction safe and only MyISAM tables support full-text indexing and searching feature. MyISAM is also the default table type when you create table without declaring which storage engine to use. Here are some major features of each table types:
ISAM

ISAM had been deprecated and removed from version 5.x. All of it functionality entire replace by MyISAM. ISAM table has a hard size 4GB and is not portable.
MyISAM

MyISAM table type is default when you create table. MyISAM table work very fast but not transaction-safe. The size of MyISAM table depends on the operating system and the data file are portable from system to system. With MyISAM table type, you can have 64 keys per table and maximum key length of 1024 bytes.
InnoDB

Different from MyISAM table type, InnoDB table are transaction safe and supports row-level locking. Foreign keys are supported in InnoDB tables. The data file of InnoDB table can be stored in more than one file so the size of table depends on the disk space. Like the MyISAM table type, data file of InnoDB is portable from system to system. The disadvantage of InnoDB in comparison with MyISAM is it take more disk space.
BDB

BDB is similar to InnoDB in transaction safe. It supports page level locking but data file are not portable.
MERGE

Merge table type is added to treat multiple MyISAM tables as a single table so it remove the size limitation from MyISAM tables.
HEAP

A Web site is a collection of information about a particular topic or subject. Designing a web site is defined as the arrangement and creation of web pages that in turn make up a web site. A web page consists of information for which the web site is developed. A web site might be compared to a book, where each page of the book is a web page.

There are many aspects (design concerns) in this process, and due to the rapid development of the Internet, new aspects may emerge. For non-commercial web sites, the goals may vary depending on the desired exposure and response. For typical commercial web sites, the basic aspects of design are:

* The content: the substance, and information on the site should be relevant to the site and should target the area of the public that the website is concerned with.
* The usability: the site should be user-friendly, with the interface and navigation simple and reliable.
* The appearance: the graphics and text should include a single style that flows throughout, to show consistency. The style should be professional, appealing and relevant.
* The visibility: the site must also be easy to find via most, if not all, major search engines and advertisement media.

A web site typically consists of text and images. The first page of a web site is known as the Home page or Index. Some web sites use what is commonly called a Splash Page. Splash pages might include a welcome message, language or region selection, or disclaimer. Each web page within a web site is an HTML file which has its own URL. After each web page is created, they are typically linked together using a navigation menu composed of hyperlinks. Faster browsing speeds have led to shorter attention spans and more demanding online visitors and this has resulted in less use of Splash Pages, particularly where commercial web sites are concerned.

Once a web site is completed, it must be published or uploaded in order to be viewable to the public over the internet. This may be done using an FTP client. Once published, the web master may use a variety of techniques to increase the traffic, or hits, that the web site receives. This may include submitting the web site to a search engine such as Google or Yahoo, exchanging links with other web sites, creating affiliations with similar web sites, etc.

Now a day’s website is a very common word, and a must required tool to reach global market, major of the corporate build website to create and corporate impression and to let people know about their product / services.

Since 2001, the approach to a website has reached it real meaning. Before 2001 website designing was widely considered to be a nice design and easy navigated flashy page. This was unable to bring results to the companies.

Now web designing is maturing and a client expects results from their website. That’s where our team strength counts into. With 20+ web designers, you have access to some of the most talented and professional website designers in the industry.

Indiawebhosting.co.uk has been assisting individuals, small and medium businesses, companies, large and small corporate and organizations in establishing Internet presence and bring results from their website designing.

The first thing you should do when working on search engine optimization is find a great keyword phrase for that page. You shouldn’t try to optimize your entire site to one keyword phrase - instead focus on writing pages for specific keywords and phrases.

The Page Description is a short blurb or summary of your web page found in the metadata. Google often uses the first 20-25 words of this description below your site name in search results. As with the Page Title, Google will bold the words that match the user’s search terms.

The Page Title is one of the most important areas Google and other search engines use to determine what is on a particular web page. Google uses your Page Title as the name of your link in search results (Google even makes the matching keywords bold) so these words have a big impact on search results. Put your keywords or phrases in the title, and keep it short.

Once you think you have found the right keywords and you’ve written your text so that these keywords appear all over the page, it’s time to check out how your site is doing. At googlerankings.com you can check your position in Google for the keywords you have chosen. Top of the ranks? Great! Not even close to it? Don’t worry, here are some tips to improve your rankings.

Daterange: (start date–end date). You can restrict your searches to pages that were indexed within a certain time period. Daterange: searches by when Google indexed a page, not when the page itself was created. This operator can help you ensure that results will have fresh content (by using recent dates), or you can use it to avoid a topic’s current-news blizzard and concentrate only on older results. Daterange: is actually more useful if you go elsewhere to take advantage of it, because daterange: requires Julian dates, not standard Gregorian dates. You can find converters on the Web (such as http://aa.usno.navy.mil/data/docs/JulianDate.html), but an easier way is to do a Google daterange: search by filling in a form at www.researchbuzz.com/toolbox/goofresh.shtml or www.faganfinder.com/engines/google.shtml. If one special syntax element is good, two must be better, right? Sometimes. Though some operators can’t be mixed (you can’t use the link: operator with anything else) many can be, quickly narrowing your results to a less overwhelming number.

Many of us webmasters don’t take time or just don’t think about setting up a custom 404 page but it seems that its much more important to setup your own custom 404 pages to avoid any missed affiliate sales, pages, or products or simply loosing your visitors to Google or someone else. It is also good Search engine Optimization practice to have your own custom 404 page

Every website needs a Sitemap big or small. Sitemap should be linked to from every page on your site. A site map will help users and search engine robots find all the important pages on your site with just two clicks. This is especially helpful if your site has a hard-to-crawl navigation menu like java script or images based navigation. For WordPress blogs I recommend downloading this free sitemap generator plugin. You can see example on my sitemap page.

Smaller sites can use second navigation bar in the footer that will act as a small mini site map. This is nothing more than all your important pages as links in the footer.

By submitting a XML Sitemap to a search engine, you are making easier for that engine’s crawlers to crawl and index pages of your site. As Google describes it in this article

“Sitemaps are particularly beneficial when users can’t reach all areas of a website through a browseable interface.”

For regular websites there are many free online xml sitemap generators, just Google it but for your WordPress blog you can use this free Google XML sitemap generator plugin as it will also create Robots.txt file which is the next Free SEO Tip.