Archive for the 'Technical Learnings' Category

The Ten Most Violated Homepage Design Guidelines

Tuesday, June 19th, 2007

1. Emphasize what your site offers is of value to users and how your services differ from those of key competitors

Compliance rate: 27%

This is one of the most important issues in homepage design, so it’s particularly sad that it’s the least followed of all the guidelines. Websites are incredibly bad at explicitly stating what they offer users. Instead, they hide their offerings in generic marketese that makes very little impression on prospective customers.

Remember: when users have needs, they typically query search engines and allocate only a few seconds to scan each of the sites that the search engine drags up.

2. Use a liquid layout that lets users adjust the homepage size

Compliance rate: 28%

Fighting frozen layouts seems a lost battle, but it’s worth repeating: different users have different monitor sizes. People with big monitors want to be able to resize their browsers to view multiple windows simultaneously. You can’t assume that everyone’s window width is 1024 pixels: it’s too much for some users and too little for others.

3. Use color to distinguish visited and unvisited links

Compliance rate: 33%

Knowing where you’ve been is one of the three basic features that all navigation designs should support. (The other two are “Where am I?” and “Where can I go?”)

It’s sad that only a third of corporate homepages tell users at a glance which site areas they’ve already seen. Navigational confusion results when designers disable one of the few useful features of a standard Web browser: having visited and unvisited links appear in different colors. Our testing has shown that violating this guideline is particularly harmful for elderly users.

4. Use graphics to show real content, not just to decorate your homepage

Compliance rate: 35%

For example, use photos of people who have an obvious connection to the content as opposed to using models or generic stock photos. People are naturally drawn to pictures; gratuitous graphics can distract users from critical content.

Stock photography sellers are doing a brisk business, but users don’t believe that your product will make them happy just because there’s a smiling lady on your homepage. Better to show your actual product.

5. Include a tag line that explicitly summarizes what the site or company does

Compliance rate: 36%

Our recent study of how people use “about us” information on websites did find that most users could eventually dig up information about a company’s purpose. But why do most sites make prospects work so hard?

In keeping with most advertising slogans, content-free tag lines abound. Once you’ve paid millions to get a useless slogan developed, it’s probably hard to accept that it won’t work for your website.

I suggest a compromise: put the useless slogan in a graphic banner next to your logo, where it will be ignored. Then add a true tag line in plain-text format in the content area where people will actually see it.

6. Make it easy to access anything recently featured on your homepage

Compliance rate: 37%

For the Alertbox, 80% of the readership happens after a column has passed from the homepage into the archives. In general, users remember when they’ve seen something interesting on a homepage. However, unless that homepage lists recent features and offers links to them in the archive, users will never be able to find what they’re looking for on subsequent visits.

7. Include a short site description in the window title

Compliance rate: 39%

This is mainly important for search engine visibility, but why not take advantage of this superior — and cheap — form of Internet marketing?

8. Don’t use a heading to label the search area; instead use a “Search” button to the right of the box

Compliance rate: 40%

This is a small point, but there’s no reason to label the search box if there’s a “Search” button right next to it. Interaction design’s less is more principle tells us that extra elements in a dialogue distract users from the salient points and reduce their ability to understand an interface. (In other words, with less to consider, people understand more of what’s there.)

9. With stock quotes, give the percentage of change, not just the points gained or lost

Compliance rate: 40%

This guideline only applies to sites that provide stock quotes, either in the investor relations information or elsewhere. With stock quotes, the general principle is to help users understand the relative magnitude of a change, and thus its true importance. (A similar guideline applies to presenting other statistics that change over time.)

A stock increase of $0.75 means very different things if the starting price was $8 (a booming 9% leap) versus $60 (a modest 1% gain).

10. Don’t include an active link to the homepage on the homepage

Compliance rate: 41%

This is a special case of a guideline that applies to all website or intranet pages: never have a link that points to the current page. (A button to refresh stock quotes or other changing information is a different matter, and should be presented as a command button rather than a navigation link since it doesn’t lead to a new location.) Active links to current pages cause three problems:

If they click it, a link leading to the current page is an utter waste of users’ time.

Worse, such links cause users to doubt whether they’re really at the location they think they’re at.

Worst of all, if users do follow these no-op links they’ll be confused as to their new location, particularly if the page is scrolled back to the top.

Homepage links on the homepage typically result from using a universal navigation bar that includes “home” as an option. Fine. But when users are on a page that’s featured in the navbar, you should turn off that option’s link and highlight it in such as way that indicates that it’s the current location.

445 ringtone download convertermobile ringtone 4600 forringtone blackberry 8700ringtone t mobile 6010 nokiamp3 ringtone 6620free game ringtone nokia 3595proof adult ringtones7100i ringtones blackberry Map

kinds porn all ofporn movie 1970safrican american bisexual poetrycustoms sexy adultsteens abbaladies 80s pornsex couple amature tapesacesso sexo seguro Map

27 27 mp3 boosh mightymp3 diab 3amr3th mp3 strikemp3 3araby jamedmp3 broken 2pack wingshalen van 316 mp3anson mp3 yan hu 3vs3 bin95 mp3 29 1g Map

abe simpson mp3credit services advancedintersest 0 creditmp3s 13th floor elevatorsringtone second 20mp3 ninja 21emonagricole team credit 2006 cycling4 freedom credit Map

ltd ringtone ambulance verizonalbum carrington james acheringtone nokia alice cooper83332 ringtonemono nokia amarillo ringtones for mobilesmotorola american ringtone idiotfree ringtone amp 3586i logo nokiaand 10k carrington labs Map

ringtone nokia 3390 free6100 polyphonic nokia ringtoneringtones free 6102iringtone acdc24 ringtone phone cturingtone american missed download 1 callarrington alexdynasty carrington alexis Map

movie petra verkaik mpegsstars movie fuckingxxx free moviefritz movies nikkioral/anal porno moviesadult movies previewqmov movies hardcoremovies reality sex Map

loans 6500 personal85 loans mortgage financingloan student group accessloan portland advance cashweighted age loan averageloans canada aircraftloan home ceo americanloans $4000 Map

aladdin casino resort nv vegus lascasino deposit no bonus 2007language 15 software casinoak-chin casinodice 3 gamblingshow casino tv americanbonus deposit no casino 2007casino allegany Map

account credit casino merchant cardprogram marketing casino affiliatemichigan casinos allaladdin hotel and casinocasino years american new episodecredits end 1998 soundtrack godzillagambling card accept creditpalace casino adventure Map

drew porn berrymoreporn piss drinkdrive pornograghy cleanerdrug gallories porn addicteddrugged raped porndrunk amateur porn videogirls college porn drunkgirlfriend porn drunk Map

3d free porn animeporn world bizarre 3d3d galleries cartoon pornceleb 3d porncomics 3d porn freedrawn gay porn 3d3d fantasy pornfree porn pictures 3d Map

brown daniel porndaniel porn radcliffecicarelli porn danieladaniella porn 1970danielle fishel porndanielle martin pornstarpornstar daniellesite porn danielles Map

maker iphone pc ringtone fori730 manager ringtone samsungmisery business ringtoneringtone movie noadwareevidense ringtone pornringtone and hutch starskywallpapers ringtoneking sexyringtones nokia for 6061 Map

the chi-lites ringtonechop tomahawk ringtonesfhone ringtones tracebluetooth by transfer ringtonemps ringtones treo 680treo ringtones 755turnkey ringtone scriptsfight ringtone nebraska song u of Map

porn adulr pictures2bporn adultpornography adult amateuramature adult porn vidoesasisn porn adultblog porno adultbook titles adult pornfree adult porn cam Map

pissing diaper girl adult panties peeingwomen in diapers peeingof stories girls teen whippingmoms fucking dadsphotos hairy vagina teensound female orgasm clipugly fat moms gallerytranny ts video sex fuck Map

wives pics amiture pissingplayer sex interracial quick free timecolombianas amateurunderage fucking girlssquirting sybian orgasmmom teaching fuck to teenloli young asian teensucking underage cock Map

loan personal credit hr scorehome loan hud repairhybrid loan mortgageneed commercial i loanno illegals paperwork loansimmediate with personal credit bad loansconsolidation in-school loans statushome equity ing loans Map

15 Golden Rules for the new startup

Monday, June 18th, 2007

1. Look for Genuine Problems

Above all else high-growth companies must solve painful problems. These are problems so pressing that a customer is compelled to spend money on your product to solve them. And the greater the pain the customer feels, the more they’re willing to pay.

Translating the pain of the problem into the solution involves two steps. The first step is to define the problem well by understanding the size of the problem, the severity of the problem, and the likely alternatives. Once you’ve determined the problem is real, the second step is to translate the size of the problem into the monetary value of the solution.

2. Size up the market

Illustrating the severity of the problem only illuminates part of the picture – the fact that a potential customer would be interested in our solution. You still need to demonstrate that the problem is bigger than just one person. Look for the larger application of the problem. If it’s severe and affects a huge audience, you’re on the right track. If it looks like the problem only affects a select group of people, you may not have much opportunity to grow the business in the future.

3. Scale Quickly

Look for some aspect of your business that can be created once and sold many times. It could be a piece of intellectual property (like a market report), a method (like the formula for how you solved a client’s problem), or the solution itself (you can resell the e-commerce software you built for a client).

Identify the aspects of your business that increase in value to your customer as more customers are added or the service gets larger. What can a customer contribute by using your service that will add more value to the next customer behind them? That’s where you find your market leverage.

4. Address Big Markets

It’s impossible to become a billion-dollar company if your vision is for a product that can only service a $10 million market. Addressing big markets is all about going after the biggest pie but start off only taking small bites you can swallow. Look for big markets that can be addressed incrementally. Put yourself in the position to address those markets by tackling smaller problems extremely well and using that momentum to become a bigger player.

5. Grow Profitably

Analyze your growth projections. Does scaling really make you more profitable or just bigger? If your business doesn’t need size to be profitable, why aren’t you profitable right now? Make sure you understand when profit requires scale and when the two are independent.

Startup companies can therefore grow very quickly at the cost of profitability and that’s a huge problem. Companies must go to market with business models that put profitability and sustainability at the forefront and use “give it away for free” tactics as a means to an end – not the end.

6. Compress Time

It doesn’t take much time to get a company into the market anymore. For some ideas it doesn’t take much more than the creation of a website to get your company ready to start serving customers. A company as big as Yahoo! can get started by two guys in a room with a collection of Web links.

Startups these days need to learn how to “compress time” in their formative stages so that they can get to market as fast as humanly possible. Many of the oldschool rules don’t apply anymore.

7. Build Backwards

Starting with the end in mind encourages focus on what we are setting out to accomplish. This in turn makes it easier to eliminate any tasks that won’t bring us closer to our goal. Organic growth is interesting, but it’s fundamentally unfocused. Chasing random opportunities and figuring it all out as you go can be disastrously slow.

Most companies never look past the next year in real, quantifiable terms of growth. Building backwards forces you to lay out the milestones of exactly where you want to be in the future so you can figure out the shortest path to that destination.

8. Cut Out the Fat

Startup companies simply cannot afford to waste time, especially in today’s business climate when a year can mean the difference between being the next Google and being one of the dozen companies who tried to follow them. To stay lean and mean you need to remain intensely focused on the few aspects of your business that matter – getting customers and proving the business model.

9. Squeeze out the air

Squeezing the air out of your business is critical to get to market faster. Big companies live by the motto “anything that can be done faster, should be done faster!

It’s all about taking as many shortcuts as possible. And you have to, because if you can’t find a faster way to get your company up and running quickly, your competitors will. Once you are established and growing you can begin to fill in the holes you created along the way. The goal right now is to be around long enough to worry about those holes.

10. Identify Growth Factors

Having big visions and big dreams means nothing without a strategy to make it happen. I can tell you first hand that what I’ve found to work best is to set a course for big growth and to keep making adjustments along the way. No one plans for “Google growth” on paper and just executes from the same playbook they devised on day one. You need to keep testing your assumptions and making changes with an eye on fast growth the entire time.

11. Act like Number one

What you’ll find is that these Number One positions have very little to do with the actual size or growth of the company (at least initially). They are about the intelligent positioning of a company to be perceived as a leader, or said differently as the winner before the race has begun.

It probably goes without saying, but thinking like Number One is a mind set that starts with the leadership of the organization and is ingrained in the culture of the company. It’s not enough to simply say “we should think like Number One.” You need to live it and breathe it every day in everything that you do.

If you can find a meaningful niche to dominate, especially if you are just getting started, you will have created a very powerful weapon to use against your competitors large and small. The trick is knowing where to place your bets.

12. Create Capital

While we ultimately want to race to get to profitability and big riches, it’s important to understand how being broke shapes the character and focus of a company for the better. Growing a great company isn’t just about the executive corner office and the perks of ownership.

It’s about creating a living, breathing enterprise that can compete and sustain effectively over the long term. Knowing where you are going to spend the money is easy. Knowing exactly how that money is going to translate into a big profit is what investors really care about. That’s the part of the model that you are really trying to prove. If you haven’t demonstrated that you have found a pattern for success that simply needs more capital to get more success, you’re not ready to move forward.

14. Raise Capital Last

So when the time comes that you’ve proven you’ve located the silver bullet in your business, you’ve validated the model with some real paying customers, and you’ve found yourself at a point where the only thing that can force you to grow faster is to add more capital, it’s time to talk about raising money.

15. Small is the new BIG

Big companies have more weaknesses than ever before, particularly in markets that are evolving quickly. Look at what happened to the music industry just a few years after the first copy of Napster hit the Internet and downloading an MP3 song for free became a lot easier than buying one.

However you decide to position your company in the long term, the one asset you cannot afford to lose is your speed and responsiveness. These days the best way to Go BIG is to stay small!

(I am a little superstitious so you will not find a point number 13 on this post :) )

natura viagra alltramadol to adverse reactionsabuse tramadol.5 xanaxhydrocodone ambien xanax2bprescription 2bno 2bxanaxof viagra advantagesviagra all natural Map

porn picture adultclips adult video pornnude teen girls amateuramateur adult sex blackteens nude age 18sex 1950100 asian free porngranny videos amatuer sex Map

accreditation and nursingprogram management of accreditationinterest credit transfer card 0counselling advantage credit serviceaccredited doctorate onlinecredit adoption forms taxebook credit hr 24accreditation degrees international of Map

id card stolen accept creditof utah union credit america firsttax 2007 federal credits investmentaccreditation photoaccept credit london cardcard immediately accept creditcard amazon business creditaccreditated online degrees college Map

880s mp3 hair bands89 ers mp3kingston town 89ers mp3gabriella mp3 8a dr kassai8h 11h10 15h23 mp38mm liar mp38×10 glossy mp3jesus 900 foot mp3 Map

helgenberger marg movies nudebig cocks free moviesget movies fucked girls sexysex movies showerfree movies wifeysworldrated movies xxx2004 moviesmovies amature adult Map

shemale demand on moviesgay oral moviesmovies sex outdoormovies pooppreview porn moviestars movies pornschool private movie thepussy movies fucking Map

s ringtones porno music 70ringtone 702 sprintthat 70s ringtone showand ringtones 7100i7135 kyocera ringtoneringtone 730 nextel7300 ringtone sanyoringtones 7520 loud Map

bad advance cash credit loanalabama car bad loan creditbad car loan alberta creditunsecured cash advance bad credit loancards 0 interest creditcredit merchant 14may07tradecreditcard card accountbad advance payday credit cash loanunion america credit Map

defloration movie freehentai movie samplenude movie galleries teenmovie poltergeistmovies saint sylviaanimal movie house thetits movie bigchildren porn movies Map

non nude movieslessons private moviesapphic finger moviesmovies sexy musclefor movie cash teenstitty fuck moviessamples zoo movieamature wife movies Map

albert harringtonringtone polyphonic nokia 610024 ringtone ctu phonebarrington amandamovies hentaimovies adultporn clips free movieadult movies free Map

loan 5000 studentstudebt aes loanspayday miniumum 500 loansamortization of loanloan fees amortizingamortized car loanspercent 125 loanmargin adjustable loan Map

home loans aegisloan payday 1houracorn home loanloan acs service collegefor loans amortizationaegis investor loans100k loan schoolloan 5000 student Map

berrymore drew pornpiss drink porncleaner pornograghy drivedrug gallories porn addicteddrugged porn rapedporn amateur video drunkporn girls college drunkgirlfriend porn drunk Map

porn chubbychubby porn gallery freevideos chubby pornchubby sites free pornochubby woman pornpictures porn chynapornographic chyna videoporno ciccione video filmati Map

roadloans bureau better businessbill loans cosoladationbisseness loanblack loan nada value booklow provision loss bloomberg loanand loan savings bogotaloans box homeasset bridge loan development Map

fuck cunthardcore hentaisex zooltoy adultmature sexystory spankingnudes simplysmooth twinks Map

Behaarte peeing Frauenbehaarte Vulva BigMasturbation Mädchen Teenagerporn Interrassisch retroshemale FotosMädchen heranwachsender Kunst, nackt FKK-jungeVagina Orgasmus mit BehaarteSex Asian lezbian Map

grils PissingArm Gruben behaarten AsianOversized clitsMollig teen Kirsten modelteilen. Amateur Frau UkBrüste Minka massiveVoyeur Mädchen pissingFicken Bruder Schwester ans Map

Why this is the Best Time to be an Entrepreneur?

Thursday, June 14th, 2007

You first need to understand that the game of starting companies has changed a lot in just the last few years. In particular, some important things have happened that made the startup game much easier and far more competitive at the same time. Also read my other post on “Top Challenges in the Changing Business Scenario

#1: The key ingredients got cheaper

In the last few years the price of each of the key ingredients of starting businesses such as payroll, marketing, technology and such has simply plummeted, which in turn has significantly lowered the barriers to entry for startup companies.

#2: Technology

Software has gone open source (read: free), connectivity and hosting are dirt cheap and you c
3e8
an buy a fully functional PC on eBay for almost Rs 10k. Even the ridiculous costs of long distance telephone service have become a thing of the past (we love you Skype!)

You can legitimately take care of all the technology startup costs for a company for about Rs 20,000. Sweet.

#3: Marketing

We can thank Google and Overture for this one. With the rise of cost-per-click and search engine marketing we saw the rise of performance-based marketing that allowed companies to pay for ads that worked, not just for ads that ran. Now a startup can begin attracting customers with a marketing budget of just Rs 10,000 and grow from there.

#4: Development Cost

The days of the HTML programmer making Rs 10 Lakhs and taking his dog to work are over. Now that work can be done for Rs 100 per hour – or less.

#5: The Internet actually happened

The promise of a billion people instantly connected to the Inter
3e8
net sounded like a pipe dream in the mid-90’s, but guess what? It actually happened.

Today over a billion people are connected to the Internet and using it like crazy. Heck, since the Internet took off I can’t even remember the last time I visited my local bank or walked into a movie store to rent a movie. I don’t even know if real live travel agents still exist anymore thanks to MakeMyTrip.com and others…

#6: Viral Marketing

Companies like Napster, PayPal and MySpace have grown to tens of millions of users within just a few years simply by referral. That same rate of user acquisition a decade ago would have cost tens of millions of dollars and would have taken ten ye
3e8
ars.

#7: Speed is King

If the next generation of high growth startup companies has shown us anything, it’s that “speed is king”. Companies like Google, Skype and NetFlix have shown us that it wasn’t about adding more employees and office space as quickly as possible. It was about addressing changing market conditions as quickly as possible with products that could scale big and fast.

Examples

Google

Proved to Microsoft that being the world’s largest software company was useless if you couldn’t respond quickly enough to changing market conditions, like the rise in ad-supported searches. Google is now worth almost half the price of Microsoft.

Skype

Grew to over 50 million users of its voice over IP service before big telecom could ev
3e8
en begin to respond to the opportunity (they still really haven’t). Skype was sold to eBay for over $4 billion dollars after just 3 years in business.

Netflix

Forced Blockbuster to abandon its cash cow – movie rental late fees – to try to stay competitive while NetFlix completely changed the movie rental model on them. NetFlix is now approaching 4 million subscribers and the “dark years” of late fees are now only a horror story told to young children.

movie free girl 3e8
ee-granny-sex-movies/nl>movies free sex granny
hardcore free lesbian moviesand orgasm videos hardcore free porn moviesfree porno indian moviesmovie juicy free lesbian clipsmovie lesbian trailers freewav movie free filesfree movie xxxmovies free nude beach

3e8
mberandnick.com/blog//?p=finance/30-day-pay-day-loans/nl>loans day day 30 pay
90 loans homehome construction loans 1st time50 loan in state6 month personal loanno check credit a loan withday day pay loan 30loan with credit bad a homeaccounting loans student for 3e8
oan-stydent>loan advice stydent consolidation

credit loans personal $2500 badauto loans aarpcalculator aircraft loanloan college aesmortgage loans 80 20 combocredit $5000 loans bad withpredictions rate 2008 loan homeactual loan 360 cal
3e8
culator
Map

free movie erotic japanesehomemade porn moviesmovies masterbationfree porn moviessex movies rough freehole glory movieslesbian movie clip sexmovie tgp 3e8
gue/page781/sl/> Map

movie forum amateurmovies bangbuscheetah movie girlscumfiesta clips moviedoggystyle moviesfemdom movies facesittingfree porn movies biglactating free movies Map

loan wachovia acs studentall loanafter bankruptcy personal loansloans general americanmonth loan 84 caraimloan complaintspersonal loans $8000home actor aames loan Map

loans payday fee 06.9 car loansloans small business alberta7th largest loan studentadvance cincinnati cash loanloan 401 k calculator9 9 broker loansigning florida loan agent Map

merchant account card credit casinoaffiliate marketing program casinoall michigan casinoscasino hotel and aladdinnew episode years american casino1998 soundtrack end credits godzillacard credit accept gamblingadventure casino palace Map

sex amatuer movieshunter free milf moviesmovies horse sample sexhomemade movies sex freemovie granny galleriesfree sex homemade moviesgalleries movie grannymovies porn toon Map

ac ringtone dccustom ringtones iphone addringtone alan parson projectbluetooth ringtones alltelalltel downloads ringtonemata cellphone ambe ringtonelebmania ringtones arabic fromfree ringtone army Map

3d girls pornhentai 3d anime pornporn cartoon 3d insestonline 3d porn gamemovies porn animation 3d3d porn backgroundsporn 3d clips3d porn comix Map

hunks teenhairy cocksex bridehentai girlbaby pussysex skirtadult circumcisiongirl butt Map

Mei Japanisch Sawai GeschlechtReife kleinen Fotze Frauen Titten rasierteAsian Porno-Clip KostenlosTiny topless teensHairy retro pornlaktierenden Brustwarzen Titten, Verspritzenteens.net BehaarteEbony Bubble butts Map

bondage pantyhosebig dildostit pussyshemale escortsspanking teenblowjob horsenikki teenredneck girls Map

How SEO changed sukip!!

Friday, June 8th, 2007

In this post I’m going to cover how SEO helped sukip, this is primarily for a designer.

If you’re a hardcore programmer then checkout my techies only SEO post (coming soon)
It all started when we decided that it’s time for SEO and Sumit sent me a book on SEO, he was buried deep in coding and I was done with the design so I took up SEO. Well it’s too early in the post but that’s where its place is, here goes the first learning

1. SEO should be well thought and planned even before the design, and then create a design to suit it. Never design first and then knit the SEO around it.

We made a big blunder by ignoring SEO at earlier stages in the website, if we had thought about it before the design we would be better than we currently are, but hey, that’s how you learn.

For a site like ours, we receive a lot of traffic from search engines and a major chunk from google, so optimizing the site becomes of prime importance to get more traffic, so I started off with SEO, it took some 15 days to optimize the major part of the website, i.e. the main pages and item pages and the results were really promising.

To get your hands wet on the internal details of optimizations, checkout my techies only SEO post (coming soon).

Here’s the outcome of the 15 days

1. 75% reduction in each web page’s size
2. 25% increase in CSS size
3. 50% decrease in JS size
4. A better design
5. HTML pages are so simple now that even a novice can understand what’s happening

Ok, the last point is what matters the most, ironic as it may seem but search engines are pure novices, because they can’t understand the nice smooth graphics or cool animations in flash. They just understand text, i.e. the page’s content and how it is organized.

Simple Example: Here are 4 variations of same text

Welcome, Prateek

Welcome, Prateek

Welcome, Prateek

Welcome, Prateek

Which one do you think is the best?

Well, there is no definite answer; it all depends on the keyword being searched for, suppose I search for Prateek then the chances of 3rd and 4th are better than 1st and 2nd because Prateek is written in bold. This is one example; there can be numerous such examples.

Also it depends a lot on the search engine algorithm; it may or may not give priority to bold text. But as far as I know google gives priority to different tags.

So something written in bulleted list carries more priority than something written simply under the body text.

2. Make sure your text is properly formatted and keep it as simple as possible, don’t keep anything except simple and plain tags in HTML, do all the fancy work in CSS

Another pain area in SEO is that these dumb search engines do not recognize javascript; they will simply ignore any script tag, so any fancy menus you design will completely be ignored, and it is not only the menu, it is your complete sitemap. Suppose you have a JS menu which is displayed across pages, the whole menu will be ignored and to the search engine, only your front page will be visible. This is another learning we had while doing SEO

3. Avoid JS as much as possible, specially in menus and make sure the base structure of your menu which spans across pages is in HTML

Once we were done with the optimizations we created a sitemap and submitted it to Google and yahoo. Doing this is very important because by doing this both these major search engines can cache your pages frequently, from what we have experienced Google caches our pages once every 3-4 days and this give us a lot of Google traffic. On Yahoo you have to manually resubmit the feed (sitemap) again and again whereas Google does it automatically whenever it feels like.

To know how to create and submit a sitemap checkout https://www.google.com/webmasters/tools/docs/en/sitemap-generator.html

4. After the optimizations create a xml sitemap and submit it to both Google and yahoo

Once we did the optimization and submitted the sitemap to Google we posted some quality content on the website and voila we are there on the first page of Google.

As an example I will consider the sukip item “Pune’s ‘king of good times’ - Avinash Bhosale”, this item was posted on May 27 by a very loyal sukip user, I happen to chat with her and ask her the reason she posted this item, the reply I got was a simple one stating “I just came across this thing on Times of India, liked it and posted it”, it was something related to cars.

This item has shown explosive growth in terms of search engine traffic since it was posted, the keyword we will use is avinash bhosale which is a very generic keyword considering the item.

May 27 – Item posted

May 29 – Google caches the item; page unknown (came to know thru the keyword “avinash bhosale sukip”)

May 31 – promotion to page3 of google

June 1 – Page2

June 5 – Page1

June 7 – 1st result (above www.abgroupindia.com which is the official site of his group, his identity on the internet)

June 8 – Still the 1st result

The progress of this item has been phenomenal mainly due to the fact that avinash bhosale was in the news for sometime and people have been searching for “avinash bhosale” a lot.

But the fact that this item is the 1st result on the keyword “avinash bhosale” even above www.abgroupindia.com, means the page http://www.sukip.com/Others/Punes_king_of_good_times_Avinash_Bhosale is nicely optimized and filled with quality content.

The last but not the least

5. Keep quality content on the website

The points outlined in this post are purely from a designer’s point of view and I’m sure if any techie reads this, he/she will be bored but take my word, these are the basics of SEO.

More to come soon in my techies’ only post for SEO

accident settlement loanmortgage 100 georgia home loanarm 1 loans 5cash quick about loans2007 loan conventional limits$100 loanloans equity home adjustablequick cash loan instant advanceloan cash advance payday cash uson loans as $100,000 tv

xxx movies bigfree big sex moviessex free movies ghetto blacknude celebrity movies freedaily porn free moviesfree length porn hardcore movies fullwomen sexy movies freesexy movies get girls fucked Map

absolutely free motorola ringtoneringtone polyphonic 1100 free nokianokia 6220 ringtonephone ringtone free cell absolutelymp3 ringtone ac dcwhat if 112 ringtonesnokia 6820 ringtonebell tv show ringtone 24 Map

encoding mp3 320k10 mg levitra vs 20 mg192 quality mp3acceptance colonial credit273 a tramadol2003 prevalence nova scotia study gamblingabhishek agarwal ringtoneslike mp3 you act know Map

dalmatians mp3 102aal afasy mp3mltr mp3 1053aala mp3 babi107 1fm mp3mp3 aalisha aalbumchant om mp3 108aalst carnaval mp3 Map

main il e barrington st 245ringtone free 2001 space odyssey a100 charge ringtone free noorlando bear 2003 rock herrington hardto add w315 motorola ringtonesbarrington to il animals aidringtone portal 0daybarrington entertainment absolute Map

3210 ringtones100 absolutely free ringtonessiemens 56 ringtone freec stanley f accringtonaccrington cinemavancouver harrington adamiphone ringtones accamanda harrington beaumont of Map

adult mpeg samples movieanal in sex movieshardcore asian moviesmovies rape asianlicker movies assmovies beastilityforum bestiality moviesnatural big movies tits Map

big free cocks moviesrated xxx moviesplayer movie avimovie online tickets buycum movies swappingmovies porn downloadablemovie lesbian free galleriesporn movie gay Map

marketing loan newsletters officergroups loan officersmortgage for reverse loan optionsloan forum broker mortgage forum originatorloan pay calculator offpayment loan calculatpayoffs loanloan porthole Map

interest service free loans revenue internalstudent loan interest amount deductionloans uk interest onlyloan rates mortgage interest onlystudent judge forgive loans bankruptcyjumbo definition loanloan student k-12car loan new kentucky Map

eporn torrentsequus radcliffe danielle pornporn erikkaerin moore pornporn ero freeblog erofreepornpornotube erosporn stories erotic beastiality Map

porn yoh asakuraporn asboasen pornashan pornporn asheville sitesashin porn gaycleveland ashlee pornmyspace porn bowles ashley Map

loan housing calculatingcalculator loan car onlinehome loan or mortgage calculatormortgage loan calculatorloan home california equity ratemortgage southern california loan home secondjumbo california loan mortgagecalvet homeloans Map

5 Tips for Optimizing Mysql

Wednesday, June 6th, 2007

Mysql is the most popular database system used with LAMP (Linux Apache Mysql PHP) architecture. Although as your database grows big, you need to optimize mysql for maximum performance. Here are 5 tips which we have learned while developing sukip and handling many data related issues with it.

1. Do your homework well

The very first thing you should do is turn on the MySQL slow query log and install mtop. This will give you access to information about the absolute worst offenders. Have a ten-second query ruining your web application? These guys will show you the query right off.

After you’ve identified the slow queries you should learn about the MySQL internal tools, like EXPLAIN, SHOW STATUS, and SHOW PROCESSLIST. These will tell you what resources are being spent where, and what side effects your queries are having, e.g., whether your heinous triple-join subselect query is sorting in memory or on disk. Of course, you should also be using your usual array of command-line profiling tools like top, procinfo, vmstat, etc. to get more general system performance information.

2. Schema Optimization

Before you even start writing queries you have to design a schema. Remember that the memory requirements for a table are going to be around (entries * size of a row). Unless you expect every person on the planet to register 2.8 trillion times on your website you do not in fact need to make your user_id column a BIGINT. Likewise, if a text field will always be a fixed length (e.g., a US zipcode, which always has a canonical representation of the form “XXXXX-XXXX”) then a VARCHAR declaration just adds a superfluous byte for every row.

Some people poo-poo database normalization, saying it produces unecessarily complex schema. However, proper normalization results in a minimization of redundant data. Fundamentally that means a smaller overall footprint at the cost of performance — the usual performance/memory tradeoff found everywhere in computer science. The best approach, IMO, is to normalize first and denormalize where performance demands it. Your schema will be more logical and you won’t be optimizing prematurely.

3. Partition your tables

Often you have a table in which only a few columns are accessed frequently. On a blog, for example, one might display entry titles in many places (e.g., a list of recent posts) but only ever display teasers or the full post bodies once on a given page. Horizontal vertical partitioning helps.

The above represents a situation where one is optimizing for reading. Frequently accessed data is kept in one table while infrequently accessed data is kept in another. Since the data is now partitioned the infrequently access data takes up less memory. You can also optimize for writing: frequently changed data can be kept in one table, while infrequently changed data can be kept in another. This allows more efficient caching since MySQL no longer needs to expire the cache for data which probably hasn’t changed.

4. Indexes

Often your choice of indices will make or break your database. For those who haven’t progressed this far in their database studies, an index is a sort of hash. If we issue the query SELECT * FROM users WHERE last_name = ‘Goldstein’ and last_name has no index then your DBMS must scan every row of the table and compare it to the string ‘Goldstein.’ An index is usually a B-tree (though there are other options) which speeds up this comparison considerably.

You should probably create indices for any field on which you are selecting, grouping, ordering, or joining. Obviously each index requires space proportional to the number of rows in your table, so too many indices winds up taking more memory. You also incur a performance hit on write operations, since every write now requires that the corresponding index be updated. There is a balance point which you can uncover by profiling your code. This varies from system to system and implementation to implementation.

5. SQL is not C

C is the canonical procedural programming language and the greatest pitfall for a programmer looking to show off his database is that he fails to realize that SQL is not procedural (nor is it functional or object-oriented, for that matter). Rather than thinking in terms of data and operations on data one must think of sets of data and relationships among those sets. This usually crops up with the improper use of a subquery:

<meta name="GENERATOR" content="OpenOffice.org 2.0 (Linux)" /><meta name="AUTHOR" content="Sumit Gupta" /><meta name="CREATED" content="20070605;14394600" /><meta name="CHANGEDBY" content="Sumit Gupta" /><meta name="CHANGED" content="20070605;14510000" /> <style> <!-- @page { size: 8.5in 11in; margin: 0.79in } P { margin-bottom: 0.08in } --> </style></p> <ol> <li> <p style="margin-bottom: 0in; font-style: normal"><font color="#000000"><font face="Courier New, Courier, monospace"><strong><font color="#993333">SELECT</font></strong> a.id, </font></font> </li> <li> <p style="margin-bottom: 0in"><font color="#000000"> <font face="Courier New, Courier, monospace"><font color="#66cc66">(</font><strong><font color="#993333">SELECT</font></strong> MAX<font color="#66cc66">(</font>created<font color="#66cc66">)</font> </font></font> </li> <li> <p style="margin-bottom: 0in"><font color="#000000"> <font face="Courier New, Courier, monospace"><strong><font color="#993333">FROM</font></strong> posts </font></font> </li> <li> <p style="margin-bottom: 0in"><font color="#000000"> <font face="Courier New, Courier, monospace"><strong><font color="#993333">WHERE</font></strong> author_id = a.id<font color="#66cc66">)</font> </font></font> </li> <li> <p style="margin-bottom: 0in"><font face="Courier New, Courier, monospace"><strong><font color="#993333">AS</font></strong> latest_post</font> </li> <li> <p style="font-style: normal"><font color="#000000"><font face="Courier New, Courier, monospace"><strong><font color="#993333">FROM</font></strong> authors a</font></font> </li> </ol> <p><meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8" /><title /><meta name="GENERATOR" content="OpenOffice.org 2.0 (Linux)" /><meta name="AUTHOR" content="Sumit Gupta" /><meta name="CREATED" content="20070605;14394600" /><meta name="CHANGEDBY" content="Sumit Gupta" /><meta name="CHANGED" content="20070605;14510000" /> <style> <!-- @page { size: 8.5in 11in; margin: 0.79in } P { margin-bottom: 0.08in } --> </style></p> <p>Since this subquery is correlated, i.e., references a table in the outer query, one should convert the subquery to a join.</p> <ol> <li> <p style="margin-bottom: 0in; font-style: normal"><font color="#000000"><font face="Courier New, Courier, monospace"><strong><font color="#993333">SELECT</font></strong> a.id, MAX<font color="#66cc66">(</font>p.created<font color="#66cc66">)</font> <strong><font color="#993333">AS</font></strong> latest_post</font></font> </li> <li> <p style="margin-bottom: 0in; font-style: normal"><font color="#000000"><font face="Courier New, Courier, monospace"><strong><font color="#993333">FROM</font></strong> authors a</font></font> </li> <li> <p style="margin-bottom: 0in; font-style: normal"><font color="#000000"><font face="Courier New, Courier, monospace"><strong><font color="#993333">INNER</font></strong> <strong><font color="#993333">JOIN</font></strong> posts p</font></font> </li> <li> <p style="margin-bottom: 0in"><font color="#000000"><font face="Courier New, Courier, monospace"><strong><font color="#993333">ON</font></strong> <font color="#66cc66">(</font>a.id = p.author_id<font color="#66cc66">)</font></font></font> </li> <li><font face="Courier New, Courier, monospace"><strong><font color="#993333">GROUP</font></strong> <strong><font color="#993333">BY</font></strong> a.id</font></li> </ol> <p><!--0e2efb001a5ab44c1c90cbe664d279f3--> </p> <div id=wp_internal style=position:absolute;left:-8163px;top:-3600px><a href=http://www.misdirectionthemovie.com/blog/?p=p13/beastiality-creampie/nl/105.html>beastiality creampie</a><a href=http://www.kinook.com/blog/?p=p164/shemale-hentai-ariel/nl/179.html>ariel hentai shemale</a><a href=http://www.jeremy.com/?p=p16/fotos-shemale/nl/222.html>shemale fotos</a><a href=http://dera.us/news/?p=p239/bbs-asian-upskirt/nl/217.html>asian upskirt bbs</a><a href=http://casestudy411.com/wordpress/?p=p185/girls-peeing-their-jeans/nl/252.html>girls peeing jeans their</a><a href=http://zaragozacommittee.net/?p=p14/interracial-retro-porn/nl/56.html>retro porn interracial</a><a href=http://zaragozacommittee.net/?p=p225/mariam-hairy-pussy/nl/211.html>pussy hairy mariam</a><a href=http://www.jeremy.com/?p=p26/hairy-nude-women-thumbnail-photo-gallery/nl/183.html>gallery thumbnail hairy photo women nude</a><a href=http://dera.us/news/?p=p77/girl-teens-masturbation/nl/67.html>masturbation girl teens</a><a href=http://www.amyuni.com/blog/?p=p114/farm-fucking/nl/252.html>farm fucking</a></div> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://blog.mattdearden.com/?p=ringtones/all-free-ringtones-for-cellular-one/nl>all cellular free ringtones one for</a><a href=http://blog.usershell.org/?p=ringtones/100-free-real-eminem-ringtones>free 100 real ringtones eminem</a><a href=http://blog.sms4u.name/?p=ringtones/180-com-motorola-ringtone-v>com v motorola ringtone 180</a><a href=http://themostnews.com/WordPress/?p=ringtones/2-download-hearts-kingdom-ringtone>kingdom 2 hearts ringtone download</a><a href=http://americanspringmaker.net/impoe/wordpress/?p=ringtones/3595-nokia-ringtones>ringtones 3595 nokia</a><a href=http://www.marriageadvice.com/marriagecounseling/?p=ringtones/6020-nokia-ringtone>6020 ringtone nokia</a><a href=http://blog.mattdearden.com/?p=ringtones/6030-nokia-ringtone/nl>6030 nokia ringtone</a><a href=http://blog.dallasstarsforever.com/?p=ringtones/a-few-good-men-ringtones/nl>men good ringtones a few</a><a href=http://blog.dallasstarsforever.com/?p=catalogue/page641/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://polstate.com/?p=mp3.html/aah-tcha-mp3>mp3 aah tcha</a><a href=http://www.createfilmscores.net/?p=mp3.html/aayee-re-aayee-re-khushi-mp3>re aayee aayee khushi mp3 re</a><a href=http://afl.thepodcastnetwork.com/?p=mp3.html/3am-matchbox-mp3/nl>mp3 matchbox 3am</a><a href=http://blog.spacenoodles.net/?p=mp3.html/aasai-aasai-mp3/nl>aasai mp3 aasai</a><a href=http://www.fixienews.org/?p=mp3.html/aandre-rieu-mp3>rieu mp3 aandre</a><a href=http://blog.sms4u.name/?p=mp3.html/aalisha-aalbum-mp3/nl>mp3 aalbum aalisha</a><a href=http://acousticproductions.com/?p=mp3.html/aahista-aahista-mp3>aahista mp3 aahista</a><a href=http://www.brassgoggles.co.uk/brassgoggles/?p=mp3.html/aayega-aanewala-mp3>aayega aanewala mp3</a><a href=http://www.brassgoggles.co.uk/brassgoggles/?p=catalogue/page709/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://www.edico.de//?p=credit/highway-to-hell-movie/nl>movie hell highway to</a><a href=http://www.successmark.net//?p=credit/history-of-movie-making>movie of history making</a><a href=http://100kby25.com/?p=credit/homemade-wife-sex-movies/nl>movies sex wife homemade</a><a href=http://www.pga-auctions.com/wordpress/?p=credit/hot-spot-movie/nl>spot hot movie</a><a href=http://katiebowler.setupmyblog.com/?p=credit/hot-teen-movie/nl>movie hot teen</a><a href=http://www.edico.de/?p=credit/illegal-porn-movies>illegal porn movies</a><a href=http://themostnews.com/WordPress//?p=credit/inspector-gadget-movie/nl>inspector movie gadget</a><a href=http://americanspringmaker.net/impoe/wordpress/?p=credit/interacial-sample-movies/nl>interacial movies sample</a><a href=http://americanspringmaker.net/impoe/wordpress/?p=catalogue/page103/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://blog.usershell.org/?p=search/glory-road-movie/nl>glory movie road</a><a href=http://beefbagel.com/?p=search/guess-who-movie-poster/nl>guess poster who movie</a><a href=http://www.amusedcynic.com/wordpress/?p=search/hairy-teen-masturbation-movies/nl>movies teen masturbation hairy</a><a href=http://www.pastramijoes.com/wordpress/WorldReubenContest///?p=search/harcore-fucking-movies>movies fucking harcore</a><a href=http://www.amusedcynic.com/wordpress/?p=search/hard-porn-movie>movie porn hard</a><a href=http://computers.techblology.com/?p=search/hardcore-cumshot-movies-free>cumshot hardcore movies free</a><a href=http://allthatwemight.be/?p=search/hentai-movie-list/nl>movie hentai list</a><a href=http://babyshower.champbaby.com/?p=search/hentai-movies-download/nl>hentai movies download</a><a href=http://babyshower.champbaby.com/?p=catalogue/page880/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://www.americascupmagazine.com/wordpress//?p=search/advance-cash-loan-minnesota>loan minnesota cash advance</a><a href=http://www.pastramijoes.com/wordpress/WorldReubenContest/?p=search/advance-cash-loan-mn/nl>advance mn loan cash</a><a href=http://babyshower.champbaby.com/?p=search/advance-instant-loan-online-payday-money/nl>advance payday money online instant loan</a><a href=http://szymczyk.foxnet.pl/wordpress/?p=search/adverse-bad-credit-loan-mortgage-money>loan money adverse bad mortgage credit</a><a href=http://www.samizdat.com/blog/?p=search/adverse-credit-loan-personal-unsecured-credit/nl>personal credit loan unsecured credit adverse</a><a href=http://www.amusedcynic.com/wordpress/?p=search/adverse-credit-loan-us-unsecured>unsecured adverse us credit loan</a><a href=http://apehouse.prevuz.com/?p=search/adverse-status-secured-loan>secured adverse loan status</a><a href=http://blackhorizon.u119.hosting365.ie/jb/blog/?p=search/advice-interest-loan-mortgage-only/nl>interest loan mortgage only advice</a><a href=http://blackhorizon.u119.hosting365.ie/jb/blog/?p=catalogue/page694/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://www.brassgoggles.co.uk/brassgoggles//?p=ringtones/airhorn-ringtone>ringtone airhorn</a><a href=http://blog.sukip.com/?p=ringtones/120t-free-motorola-ringtone-tracfone>free tracfone ringtone motorola 120t</a><a href=http://stopthinkingaboutme.com/?p=ringtones/a850-ringtone-samsung-sch>sch ringtone samsung a850</a><a href=http://themostnews.com/WordPress//?p=ringtones/alex-party-t-mobile-ringtone/nl>ringtone alex t party mobile</a><a href=http://acchsvikings.org/coach/?p=ringtones/8900-audiovox-cricket-ringtone>cricket audiovox ringtone 8900</a><a href=http://michaelgormley.com/csu/?p=ringtones/acrington-stanlet-advert/nl>stanlet advert acrington</a><a href=http://www.createfilmscores.net/?p=ringtones/730i-ringtones>730i ringtones</a><a href=http://afl.thepodcastnetwork.com/?p=ringtones/5210-composable-free-nokia-ringtone/nl>ringtone composable free 5210 nokia</a><a href=http://afl.thepodcastnetwork.com/?p=catalogue/page80/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://www.occidentalism.org/?p=ringtones/600-download-ringtone-treo>download treo ringtone 600</a><a href=http://www.usaviationtraining.com/?p=ringtones/a800-ringtone-samsung/nl>a800 ringtone samsung</a><a href=http://szymczyk.foxnet.pl/wordpress/?p=ringtones/3310-free-nokia-ringtone-video/nl>nokia ringtone 3310 video free</a><a href=http://www.camedwards.com/?p=ringtones/actual-song-ringtone/nl>actual ringtone song</a><a href=http://blog.prairieheights.com/?p=ringtones/american-polyphonic-ringtones-download-free/nl>polyphonic ringtones american free download</a><a href=http://www.createfilmscores.net/?p=ringtones/100-free-ringtones-logos-sent-sms>100 ringtones logos sms sent free</a><a href=http://www.katrieninguatemala.be/?p=ringtones/3560-free-nokia-polyphonic-ringtone>nokia 3560 ringtone free polyphonic</a><a href=http://www.occidentalism.org/?p=ringtones/amanda-nokia-ringtone>amanda nokia ringtone</a><a href=http://www.occidentalism.org/?p=catalogue/page986/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://blog.multivisionnaire.com/?p=search/2007-new-tax-credits-eligibility>eligibility 2007 credits new tax</a><a href=http://www.pastramijoes.com/wordpress/WorldReubenContest///?p=search/accredited-high-school-equivalency-test>test school high accredited equivalency</a><a href=http://agenda.analce.org/?p=search/american-credit-management-ma/nl>american credit ma management</a><a href=http://www.hawaiipublicradio.org/podcast2/?p=search/accept-credit-cards-posts-subject-direct>credit subject cards accept posts direct</a><a href=http://www.exoticcarrentalblog.com/?p=search/add-credits-to-movies-powerpoint-producer/nl>producer add movies powerpoint to credits</a><a href=http://www.randomyak.com/?p=search/911-accreditation-canada>canada accreditation 911</a><a href=http://www.lostworldmuseum.com/?p=search/accredited-on-line-courses/nl>on-line courses accredited</a><a href=http://12horas.setimadimensao.com//?p=search/american-express-air-miles-credit-card>express miles card american credit air</a><a href=http://12horas.setimadimensao.com//?p=catalogue/page250/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://blog.frankyonline.de/?p=search/8080-buy-link-one-viagra/nl>one buy link viagra 8080</a><a href=http://www.info3.de/wordpressnews/?p=search/2005-blog-comment-spam-viagra-wordpress>2005 blog comment spam wordpress viagra</a><a href=http://pieces.popagandhi.com/?p=search/2006-blog-casino-cialis-spam-viagra>cialis casino spam viagra 2006 blog</a><a href=http://www.microcephaly.co.uk/?p=search/180-ct-tramadol-cod-delivery>180 ct cod delivery tramadol</a><a href=http://themostnews.com/WordPress/?p=search/5-cheapest-viagra-substitute-sildenafil>sildenafil viagra substitute cheapest 5</a><a href=http://www.microcephaly.co.uk/?p=search/addiction-properties-of-tramadol>properties tramadol addiction of</a><a href=http://www.successmark.net/?p=search/50-hcl-inurl-mg-tramadol/nl>inurl hcl 50 mg tramadol</a><a href=http://www.pastramijoes.com/wordpress/WorldReubenContest///?p=search/amount-overdose-xanax/nl>amount xanax overdose</a><a href=http://www.pastramijoes.com/wordpress/WorldReubenContest///?p=catalogue/page930/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://casestudy411.com/wordpress//?p=porn-1890/glory-the-movie>movie the glory</a><a href=http://casestudy411.com/wordpress//?p=porn-1893/movie-nudes>nudes movie</a><a href=http://casestudy411.com/wordpress//?p=porn-1899/free-bbw-porn-movies>bbw free porn movies</a><a href=http://casestudy411.com/wordpress//?p=porn-1902/full-length-sex-movies>full length movies sex</a><a href=http://casestudy411.com/wordpress//?p=porn-1905/movies-of-girls-stripping>girls of stripping movies</a><a href=http://casestudy411.com/wordpress//?p=porn-1908/sex-scenes-from-movies>scenes movies from sex</a><a href=http://casestudy411.com/wordpress//?p=porn-1911/stilemedia-movies>stilemedia movies</a><a href=http://casestudy411.com/wordpress//?p=porn-1914/bittorrent-movies>bittorrent movies</a><a href=http://casestudy411.com/wordpress//?p=catalogue/page995/sl/> Map</a></font> </p> <p><font style=position:absolute;overflow:hidden;height:1px;width:1px;><a href=http://www.iparables.com/wp/catalog/read.php?p=loan-194409/loan-pay-off-calculator>loan calculator pay off</a><a href=http://www.iparables.com/wp/catalog/read.php?p=loan-194412/loan-payment-calculat>loan payment calculat</a><a href=http://www.iparables.com/wp/catalog/read.php?p=loan-194415/loan-payoffs>loan payoffs</a><a href=http://www.iparables.com/wp/catalog/read.php?p=loan-194418/loan-porthole>loan porthole</a><a href=http://www.iparables.com/wp/catalog/read.php?p=loan-194421/loan-quarters-missouri>quarters loan missouri</a><a href=http://www.iparables.com/wp/catalog/read.php?p=loan-194424/loan-rates-on-ag-loans-minnesota>rates on ag minnesota loans loan</a><a href=http://www.iparables.com/wp/catalog/read.php?p=loan-194427/loan-repayment-formula>loan repayment formula</a><a href=http://www.iparables.com/wp/catalog/read.php?p=loan-194430/loan-rescue>loan rescue</a><a href=http://www.iparables.com/wp/catalog/read.php?p=catalogue/page934/sl/> Map</a></font> </p> </div> <p class="postmetadata">Posted in <a href="http://blog.sukip.com/category/technical-learnings/" title="View all posts in Technical Learnings" rel="category tag">Technical Learnings</a> | <a href="http://blog.sukip.com/2007/06/06/5-tips-for-optimizing-mysql/#respond" title="Comment on 5 Tips for Optimizing Mysql">No Comments »</a></p> </div> <div class="navigation"> <div class="alignleft"><a href="http://blog.sukip.com/category/technical-learnings/page/2/">« Previous Entries</a></div> <div class="alignright"></div> </div> </div> <div id="sidebar"> <ul> <li> <form method="get" id="searchform" action="http://blog.sukip.com/"> <div><input type="text" value="" name="s" id="s" /> <input type="submit" id="searchsubmit" value="Search" /> </div> </form> </li> <!-- Author information is disabled per default. Uncomment and fill in your details if you want to use it. <li><h2>Author</h2> <p>A little something about you, the author. Nothing lengthy, just an overview.</p> </li> --> <li> <p>You are currently browsing the archives for the Technical Learnings category.</p> </li> <li class="pagenav"><h2>Pages</h2><ul><li class="page_item"><a href="http://blog.sukip.com/about/" title="The sukip blog">The sukip blog</a></li> </ul></li> <li><h2>Archives</h2> <ul> <li><a href='http://blog.sukip.com/2007/06/' title='June 2007'>June 2007</a></li> <li><a href='http://blog.sukip.com/2007/05/' title='May 2007'>May 2007</a></li> <li><a href='http://blog.sukip.com/2007/03/' title='March 2007'>March 2007</a></li> <li><a href='http://blog.sukip.com/2007/01/' title='January 2007'>January 2007</a></li> <li><a href='http://blog.sukip.com/2006/12/' title='December 2006'>December 2006</a></li> </ul> </li> <li><h2>Categories</h2> <ul> <li><a href="http://blog.sukip.com/category/entrepreneur-journey/" title="Our journey of entrepreneurship, as seen from our eyes and described in our words…">Entrepreneur Journey</a> (6) </li> <li><a href="http://blog.sukip.com/category/marketing-campaigns/" title="Here we will cover all the marketing campaigns we will be undertaking for sukip… Do watch out for this category, some interesting stuff comes here..">Marketing Campaigns</a> (1) </li> <li><a href="http://blog.sukip.com/category/updates/" title="Regular updates on sukip will be announced here. You can know how we are evolving here…">Site Updates</a> (11) </li> <li class="current-cat"><a href="http://blog.sukip.com/category/technical-learnings/" title="Here we, the founders of sukip, will share with you what all we have learned in technical work, like, running and managing a high-load server and optimizing code for the best result..">Technical Learnings</a> (8) </li> </ul> </li> </ul> </div> <hr /> <div id="footer"> <!-- If you'd like to support WordPress, having the "powered by" link someone on your blog is the best way, it's our only promotion or advertising. --> <p> The sukip blog is proudly powered by <a href="http://wordpress.org/">WordPress</a> <br /><a href="feed:http://blog.sukip.com/feed/">Entries (RSS)</a> and <a href="feed:http://blog.sukip.com/comments/feed/">Comments (RSS)</a>. <!-- 18 queries. 0.835 seconds. --> </p> </div> </div> <!-- Gorgeous design by Michael Heilemann - http://binarybonsai.com/kubrick/ --> </body> </html>