ok so my site is dynamic and uses php and mysql. I run a couple of queries to build the structure dynamically but the way i’ve done it makes a long url
what i want to do is add a short url variable into my database against a specfic page and run a query to check if it exists. so for the above it could just be ‘http://www.mcsuk.org/sightings’ with the sightings being a variable in the ‘shorten’ column that is checked against the database and redirected to the full url page if it exists.
if i have a query on my index page that checks for a corresponding entry in the database before continuing on as normal or redirecting will it severly slow the site or will it be negligable? it will run this query everytime the home page is loaded.
hope that makes some kind of sense.