How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Oba Please How Do I Optimise My Forum for search engines? because i need more traffic to my forum, Thanks. Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Hafsoh I forgot to optimise your Forum for SE * Avoid duplicate content - Multiple links to … database optimise Programming Web Development by praveen_dusari hi, i have developed a shopping cart using php mysql, it has around 50 products in home page its taking too much time to load can anyone suggest how to optimise my database so that it takes less time Optimise table structure Programming Databases by MARKAND911 I am having a table named "Society" And 5 master tables "BlockA","BlockB","BlockC","BlockD","BlockE". The "Society" table contains the foreign key columns of all the 5 master tables. Now when i write the select query it takes a lot of time to execute, as 5 tables are … Re: Optimise table structure Programming Databases by BitBlt Not knowing what your table structures are, or what your data looks like, I can only give generic advice, or things to look for. 1. Using "select *" will bring back every column from a table. You can increase speed by only bringing back the columns you actually need. 2. What are the datatypes and sizes of the columns? Large VARCHAR … Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by techniner Do some homework on URL rewriting. You maximize your exposure to th engines by re writing on target keywords. Don't be too broad, narrow down to only relevant subject matter and tag urls with keywords. Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Oba [QUOTE=techniner;540365]Do some homework on URL rewriting. You maximize your exposure to th engines by re writing on target keywords. Don't be too broad, narrow down to only relevant subject matter and tag urls with keywords.[/QUOTE] Can you give some details about URL rewriting? Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by ~Calyxto~ through link building and social bookmarking! Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Oba Your mean linkexchange? Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Hafsoh link exchange is part of link building, others techniques includes: * forum posting in related forums * ads posting * RSS Submission * Directory submissions * Blogging * Viral Marketing with ebooks on forum marketing * Comment Posting on related sites * social bookmarking * press release make it news worthy Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Oba Thanks Hafsoh and others. Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by AussieWebmaster also the naming convention of the categories of the threads will help... just make sure they default as the title Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Oba [QUOTE=AussieWebmaster;551404]also the naming convention of the categories of the threads will help... just make sure they default as the title[/QUOTE] They do already. Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by seoindia5 Also make sure not too many people are advertizing in your forum as it may harm your ranking. Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Oba I have only google adsense on my forum as ad, so can google harm google? Re: How Do I Optimise My Forum? Digital Media Digital Marketing Search Engine Strategies by Oba Hey guys, I'm back to let you know that your advices are working fine for me. Thanks all for your contributions. Re: database optimise Programming Web Development by cwarn23 A common problem we all experience when a noob to displaying huge databases. This is where you need to use [URL="http://www.daniweb.com/code/snippet612.html"]pagination[/URL]. Try Googling "php pagination" as i've rarely used it myself and the above link contains an example. Re: database optimise Programming Web Development by praveen_dusari i have done navigation many times but i donot need pagination,i have done many ways to reduce the burden on database like instead of using select * i used select id,name,price like that.i takes more than 10 sec to load on fast internet too i personelly think it too much time any ideas? Re: database optimise Programming Web Development by cwarn23 Well from experience, if you have a database that is longer than 80 rows then that is when pagination will be needed. The only thing that is stopping it from loading faster is the cpu speed. Weather php is only using a proportion of your cpu or the job exceeds the cpu available, it is generally cpu that determines the time for a page to execute (… Re: database optimise Programming Web Development by praveen_dusari correct me if i am wrong,i my office all systems are equally configured and our team leader uses internet which is much faster than us in his system my page took 8 sec to load and in my system it took more than 10 sec to load ,it depends on net speed i think, and is there a concept like compressing php page in server and sending it to browser… Re: database optimise Programming Web Development by cwarn23 [QUOTE]is there a concept like compressing php page in server and sending it to browser?[/QUOTE] I'm not sure if anybody has thought of that before but that's a great idea for sending large amounts of html data to the user. I suppose you would use php to encode the data and javascript to decode the data. Never thought of that before. Anyway, as… Re: database optimise Programming Web Development by kireol I would start by reporting the timing of my queries. I assume you are doing more than 1 query. Record the start and end times of each query. Then look at the slowest query, paste it here, and see if people can help you optimize it. Re: database optimise Programming Web Development by praveen_dusari i used only one query to show the products.is there no other techniques to load the contents faster other than using less queries may be i should use more div tags and css style sheets :-/ rather than using tables may be this will work Re: database optimise Programming Web Development by kireol 1 query should take less than 1/4 of a second at most. not 8 seconds. Re: database optimise Programming Web Development by praveen_dusari yeah query takes less than a sec but to load contents like product images,it takes time, it should load around 40 images thats why i asked is there any method in php that will compress before sending.. Re: database optimise Programming Web Development by Josh Connerty So it is infact your HTML document and not the PHP? To test if your PHP document is taking a very long time try taking down a time stamp at the start and the end of your PHP document. Then at the end minus the start from the last. IF this returns false then your script is executing like it should. If it is a second or more (if the result of the … SpeedUp Your Window XP Never Than Before Hardware and Software Microsoft Windows by fishyking … the Indexing services 7. Click Next [B][U]OPTIMISE DISPLAY SETTINGS[/U][/B] Windows XP can look sexy…all the visual items can waste system resources. To optimise: 1.Go to Start 2. Click Settings 3.… and Save Cacheman 4.Restart Windows [B][U]OPTIMISE YOUR INTERNET CONNECTION[/U][/B] There are lots of… Everything you wanted to know about undefined behaviour (but were afraid to ask) Programming Software Development by Salem …, this is basically a choice between "optimise for space" or "optimise for speed". The compiler results are presented… 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… 7 Tips to Keep your PC Running At Peak Performance Hardware and Software Microsoft Windows by Dani …;en-us;234749[/font][/url] [font=Century Gothic]************************************** Step Six: Optimise your system ************************************** A few basic pointers for optimising your system…