Tryangled Solutions web designing tips tricks

MySQL provides many extentions to SQL which help performance in many common use scenarios. Among these are INSERT … SELECT, INSERT … ON DUPLICATE KEY UPDATE, and REPLACE.

I rarely hesitate to use the above since they are so convenient and provide real performance benefits in many situations. MySQL has other keywords which are more dangerous, however, and should be used sparingly. These include INSERT DELAYED, which tells MySQL that it is not important to insert the data immediately (say, e.g., in a logging situation). The problem with this is that under high load situations the insert might be delayed indefinitely, causing the insert queue to baloon. You can also give MySQL index hints about which indices to use. MySQL gets it right most of the time and when it doesn’t it is usually because of a bad scheme or poorly written query.

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.

<maps.google.com>: What’s different? You can click-n-drag across the maps; fast magnification of specific spots along the map; satellite and hybrid images - all using Web 2.0

See these Google Maps mashups (web application hybrids):

* HousingMaps.com: marriage of Google Maps and Craigslist real estate postings
* Gmaps Pedometer | MapMyRun.com: virtual pedometer
* NYsee.net: traffic webcams
* Traffic info
* ChicagoCrime.org | NewHavenCrimeLog: track local crimes
* CellReception.com: cell towers near you
* HotOrNot + Google Maps
* MapYourAncestors.com
* LifeHack.org’s Google Maps resources
* Google Earth (PC and Mac, recently updated)
* Google Moon | Google Mars
* Read my column on creating your own Google Maps

Make a short cut with target
%SystemRoot%explorer.exe /n, /e, D:

How can I get my site listed with search engines? It sounds like a pretty simple question, but sadly, search engine submission can be a complicated subject.

Have no fear. This guide will take you through the essential and relatively easy steps you can take to get listed with search engines.

Before we begin, it’s important to make a distinction between search engine submission and search engine optimization. These terms, along with others, are sometimes used synonymously to discuss different efforts to promote sites on search engines. However, within this section of Search Engine Watch, they will be used to refer to some very specific activities.

Reading Google’s patent filing it appears that they rely heavily on web site links and anchor text in their algorithm. The items below were some of the items the patent said they look for:

* Tracking of the appearance and disappearance of links over specific times
* Tracking of growth rates of links in other web sits
* Tracking of anchor text and dates established and how they change over time
* Older established links get a higher rating than newer less established links
* Fresh pages might be considered more important
* New web sites don’t normally have a lot of links, but if they come from established web sites they will be tolerated
* Older pages that don’t change very often but have incoming links growth over time can be considered fresh
* Burst link growth may indicate spamming of the index
* Anchor text should vary and not be the same from all incoming sources
* Web site link growth should be consistent and slow