Re: Optimisation of query Programming Databases by javedsai … of the sql query. Can u plz help me in optimisation. Also, I moved 3 where conditions with the corresponding left… On page optimisation... Digital Media Digital Marketing Search Engine Strategies by seodevid hi can anybody plz tell me the information about on page and off page optimisation... I dont know the information for on page optimisation and how can i do on page optimisation for the site plz tell me methods or share ur ideas about on page optimisation plz tell me the how many steps are under on page optimisation.... Thnx .. Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by muaazab … about on page and off page optimisation... I dont know the information for on page optimisation and how can i do on… tell me methods or share ur ideas about on page optimisation plz tell me the how many steps are under on… page optimisation.... Thnx ..[/QUOTE] You got so many replies that I think… Search engine optimisation for small business in Layman’s terms Digital Media Digital Marketing Search Engine Strategies by kronikmedia …as Google and Yahoo. <b>Search engine optimisation</b> is a highly specialised field that… requires experience and knowledge of different search engine optimisation techniques that can help increase the rank of a… one of the first steps in the search engine optimisation process. Using tools a search engine marketing consultant can… Particle Swarm Optimisation Programming Computer Science by swinefish … problems that can be solved fairly easily with particle swarm optimisation? I need to do a project for this, but I… problem can be solved this way (especially with ant colony optimisation) but since I've already done that with genetic algorithms… Re: Particle Swarm Optimisation Programming Computer Science by agugglez Hi there, you might want to check this pdf :[URL="http://cswww.essex.ac.uk/technical-reports/2007/tr-csm469.pdf"]http://cswww.essex.ac.uk/technical-reports/2007/tr-csm469.pdf[/URL] "An analysis of publications on particle swarm optimisation applications" Java and search engine optimisation Digital Media UI / UX Design by numerouno … Google Page Ranking tool. When I run my search engine optimisation tool it always picks this code up as an alert… Re: Mysql Optimisation Programming Databases by newbie14 Dear Smantscheff, Yes I am currently working on the query optimisation based on the slow query log. But on the other … Optimisation of query Programming Databases by javedsai Hi All, I need to optimise the below query. The below query takes 13 seconds to run on live. Kindly, suggest how I can optimise this query and how can I index the table? The query is as mentioned below:- SELECT *, a.forxmlfeed, a.lastupdated, a.mark_for_deletion, a.is_mixed_use, p.value as projtypeformixuse, b.active as … Re: Optimisation of query Programming Databases by pritaeas 14 left joins... Have you tried EXPLAIN ? Are you using indexes, foreign keys ? Apart from all that, if you can, put the most restrictive restriction first (to compact the result set early on). Re: Optimisation of query Programming Databases by javedsai yes there are 14 left joins. If I want to Index it then, should I apply index to project_types (tbl projects), countries (tbl areas) & customer_types (tbl enquiry_info)? Kindly suggest, I'm new to **Indexing** Re: Optimisation of query Programming Databases by javedsai Also when I run this long query then, I can't see Explain option Re: Optimisation of query Programming Databases by pritaeas Usually you can assume that you'll need an index on the fields you are joining. EXPLAIN can guide you in that. An overkill of indexes is not always helpful, and _can_ slow things down even more. The restrictions in the WHERE should IMO be moved to the matching join. Re: Optimisation of query Programming Databases by javedsai U mean I need to index those fields which are used for joining? I could not understand this sentence "The restrictions in the WHERE should IMO be moved to the matching join." Also, when I ran the above query I can't see 'EXPLAIN' option. Re: Optimisation of query Programming Databases by pritaeas You have three conditions in the WHERE that can be moved up to the corresponding LEFT JOIN ON. http://dev.mysql.com/doc/refman/5.6/en/explain.html Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by jacks smith Onpage optimization we work on keywords we use these keywords on our page title, description meta tag and keyword tags also use in alt,heading and content also and one important thing is that content is the key of seo, you can find many tutorial on seo related forum it will definitely helpful to your Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by AirTechniques Onpage Optimization is all about the tweaking of your website meta tags, keywords, content, headings, image alt, and many more. Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by vantillu On-page SEO refers to designing your website in a search engine friendly way. Off-page SEO refers to the process of getting links back to your site from other sites that the search engines consider relevant for your keywords. Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by AirForceOne Hi, In my own experiences, on page optimization would refer to how to use the targeted keywords on your pages according to those ranking factors on your pages effectively. A nice reading for on page optimization factors would be on seomoz.org/article/search-ranking-factors#overview :) have a nice day, Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by redesignunit On page optimization is most important part of seo :) Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by catheylee We can work on (on page) to make our website strong. And (off page) We can work to spread our keywords.On page optimization is most important part of seo...... Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by eoinbronks The On page optimization is the course of optimizing the content of your website. This includes the text, images and links on your website. Something uploaded to your site's domain is measured on page. Onpage optimization will not assurance any top rating inside a search engine. Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by ezestseo there are lots of things come under On-page Optimization - 1. 301 Redirect 2. Meta Tags Optimization 3. Code Minimization (Java Script, CSS, HTML) 4. Image Optimization 5. H1, H2 Tags Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by venusstephen On page optimization to improve the content of your site. It is directly related to the content and structure of the site. Typically, web pages include Hyper Text Markup Language (HTML) or other file formats will be indexed by search engines, such as Microsoft Word or PDF. The basic idea of on page optimization is to eliminate redundant HTML tags … Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by clark angus Online Optimization is related directly to website and contents structure of the website keyword density,site map xml and user facing,usability and accessibility while off page optimization is what you can do with your website remaining off the page off page optimization deals with Link building, comments posting, directory submission, article … Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by jhonybush In search engine optimization, on-page optimization refers to factors that have an effect on your Web site or Web page listing in natural search results. These factors are controlled by you or by coding on your page. Examples of on-page optimization include actual HTML code, meta tags, keyword placement and keyword density. Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by johnmark1 On Ppage optimization is not effective way to increase the page rank. I think off page is best way to increase the traffic and your site page rank. Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by mackone In on page optimization we do for the enhancement of the site. Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by xannonbourne On page and off page - there are two main types of search engine optimization. On page search engine optimization probably the simplest of these two aspects. This web page is related to the elements. That is, words, and what importance is given to the words on the page. Search engines know first and foremost want to have a web page about. So … Re: On page optimisation... Digital Media Digital Marketing Search Engine Strategies by freddavis on page optimization is a process of build website search engine friendly.it include the process keyword research, meta tag, link optimization etc. check this link [url]http://www.searchenginejournal.com/on-page-optimization-a-complete-walkthrough/6746/[/url]