Optimizing a website which uses information from a database
-
Hi,
Sorry if this question is very general. I am in the process of building a website for local business, and it it will be heavily dependent on a database.
The database will contain loads of information which can be optimized such as business directory listings, articles, forums, questions and answers etc. The businesses will also be able to link to and from the site.
Which is the best way to display this information so that it can be optimized the best? I was going to use drop down boxes on a single page, ie main category, sub catagory, then display the business listings based on this.
However, as the information on the page changes constantly based on the drop down the robot / user uses, I am assuming this is very hard to get optimized well.
Does anyone know a better way?
Thanks.
-
Ok - I will ask something else which might help (and which I might understand).
From reading around, I understand that search engines will index pages with
?category=foo&subcategory=fee on the end. Can anyone confirm this, as if this is true it will make my life a lot easier!Thanks
-
Thanks for the reply. Can you give me any examples of this, or explain how it might help. I am a beginner with regards to SEO, and not come across this term in regards to web design.
Do you mean have a file for each category, and then a page for each sub category, and another page for the listings? Can this be automated, or is it manual?
Sorry for being so Naive!
-
I don't know if this will solve your problems, but could you program the site using breadcrumb navigation? That will go a long way in your seo efforts.
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
My Website Page Speed is not increasing
HEY EXPERTS, My website page speed is not increasing. I used the wp rocket plugin but still, I am facing errors of Reduce unused CSS, Properly size images, and Avoid serving legacy JavaScript to modern browsers. you can see in the image Screenshot (7).png I used many plugins for speed optimization but still facing errors. I optimized the images manually by using photoshop but still, I am facing the issue of images size. After Google Core Web Vital Update my website keyword position is down due to slow speed. Please guide me on how I increase the page speed of my website https://karmanwalayfabrics.pk Thanks
Technical SEO | | frazashfaq110 -
Spam score on a clean website assistance
Hi there, I wondered if someone could help please? I have a site http://www.thecybermagician.com which since I last looked now has a Spam score of 33% I have gone through my links and also read the MOZ articles describing the 27 things which it may be article here: https://moz.com/help/link-explorer/link-building/spam-score but am still struggling to see why my spam score is 33% as it doesn't have any spam links coming into the site. One of the of 5% spam score I have asked for it to be removed. I wondered if you could help me please? Thanks again Duncan
Technical SEO | | derire91 -
Entire website is duplicated on 2 domains - what to do?
My client's website has 1000+ pages and a Domain Authority of 23. I have just discovered that the entire site is duplicated on a second domain (main URL = companyname.com - duplicate site URL = company-name.com). The home page of the duplicate domain has a 301 redirect going to the main domain. However, none of the 1000+ other pages have any redirect set up, so Google is indexing the entire duplicate site. I'm assuming this is a bad thing for SEO. Duplicate site has a domain Authority of 4, so I'd like to transfer whatever link juice it has, towards the main site. What's the best thing to do? Ultimately I think it would be best to delete the duplicate site. So would it be a case of adding a redirect to the htaccess file along the lines of: redirect company-name.com/?slug? to https://companyname.com/?slug? (I realise this isn't the correct syntax - but is the concept correct?) Has anyone ever dealt with this successfully?
Technical SEO | | BottleGreenWebsites0 -
Optimizing Forums
Hello Moz Team, I'd like to inquire about our forums section on how to optimize them the best way. So, we started a forums section and our audience likes them very much, we were able to get a few hundred subscribers and it has been very active http://violintutorpro.com/forums/ I created a campaign in Moz Analytics and it came back that we had tons of dupe content, all coming from the tags in the forums. We can remove the tags just so we won't have dupe content, but, how can we use each topic as a content on their own. We currently have a few hundred of dupe content.
Technical SEO | | jac.reyes0 -
Page authority old and new website
Dear all, I tried to find this question using the search option but cannot find the exact same problem. This is the thing: I launched a new website in January, replacing our old website that did pretty good in the SERPs. The old website is still running on a subdomain old.website.com and the new website is on www.website.com (www.denhollandsche.nl) Both sites are indexed by google right now, but I'm not sure if that's a good thing. For our main keyword, the page on the new website has an authority of "23" and the exact same page (some minor differences) on the old website still has an authority of "30". Both currently are on the second page of google while some time ago, they where still on position 2/3/4. My question is: if I would take down the old website and make a 301 redirect for the old page with P/A 30, to point to the new page with a P/A 23, will the p/a of this new page take over the P/A of the old page? What effects can I expect? The reason the old website is still running is that google images still shows images from old.domain.com in stead of images from the new website... Thanks for your help guys!
Technical SEO | | stepsstones0 -
Website not ranking for noncompetitive terms
Hi, We've took over a website last July and no matter what we do we just can't get it ranking in Google, even for noncompetitive terms. here is the website in question: http://www.alignandsmile.co.uk Ideally the client would like to rank for Canary Wharf but that location is competitive, the site doesn't even rank for 'Dentist New Providence Wharf E14' despite it being included in the title tag on the home page and in the content throughout the website. Directories with Align and Smile's business information do rank however. I opened a case with google through Webmaster tools and they 'reviewed your site and found no manual actions by the webspam team that might affect your site's ranking in Google.' So I'm a bit stuck. The site ranks top for the keyphrase in Bing and Yahoo...we are really struggling with Google! Any help would be much appreciated. many thanks Marcus
Technical SEO | | dentaldesign0 -
Anchor Text the best way to use it
Hi i am wanting to gain links to my site and make the links relevant and have seen many sites that do not have the keyword on their site and have been told as well as having the keywords in the image that they will also have anchor text from other sites. Can anyone please tell me the important of anchor text and how i should use it. Is it wise to build anchort text links within your own site and what other sites should you be looking for. I have used a few article sites to gain anchor text links but most of these are no follow which does not help me. any advice would be great
Technical SEO | | ClaireH-1848860