Please help solve a debate!
I am in somewhat of an argument with a forum developer regarding "friendly seo" urls.
What they are saying:
Having the "ID" of the thread in the URL is necessary because if it wasn't, the database query would change from:
SELECT * FROM topics WHERE tid=X;
SELECT * FROM topics WHERE title_seo=X;
My question to you guys is:
Does mod_rewrite change the way databases are queried when a user visits a link?
If you visit this topic from a link someone posts elsewhere you're going to be linked to this
So, lets take your proposal and remove the ID
The only way to find the content is from the title. So you HAVE to do an initial search of the database using the title in order to get the topic ID. You can't search by topic ID if you don't have it in the URL.
Additional, my next question is even if this is true, how much of an effect would this have on those database queries? In other words, would it make the queries so inefficient that it would bring the server down or cause a decrease in load times?