Sitemap, mod_rewrite, MySQL & PHP
Posted: Wed Jul 25, 2012 5:52 am
Afternoon everybody,
I am trying to find a solution to a problem. I have a database table that contains product data. The total product count varies between 500,000 records and 3,500,000 records daily.
data is searched, results returned and products viewed via a single php page which uses the format "page.php?id=1"
I am looking into using mod_rewrite to allow me to be able to make the URL's more meaningful to improve search engine visibility. The intention is to rebuild a Sitemap daily after the nightly database update.
However, after doing some reading I can see that mod_rewrite takes it's configuration from .htaccess files. So, I have a concern right now, which is how well will the server cope with 3,500,000 extra lines of code? My expectation is that it won't cope at all and it would be a disaster.
Ideally I am looking for a URL that has the product title in it. In my DB product title may NOT be unique, so using the product title to do a product lookup is not an option.
So, there must be an easier solution within PHP, but I am unsure of what that might be at the moment. Does anybody have any suggestions how I can achieve my goal?
Thanks,
Noodle
I am trying to find a solution to a problem. I have a database table that contains product data. The total product count varies between 500,000 records and 3,500,000 records daily.
data is searched, results returned and products viewed via a single php page which uses the format "page.php?id=1"
I am looking into using mod_rewrite to allow me to be able to make the URL's more meaningful to improve search engine visibility. The intention is to rebuild a Sitemap daily after the nightly database update.
However, after doing some reading I can see that mod_rewrite takes it's configuration from .htaccess files. So, I have a concern right now, which is how well will the server cope with 3,500,000 extra lines of code? My expectation is that it won't cope at all and it would be a disaster.
Ideally I am looking for a URL that has the product title in it. In my DB product title may NOT be unique, so using the product title to do a product lookup is not an option.
So, there must be an easier solution within PHP, but I am unsure of what that might be at the moment. Does anybody have any suggestions how I can achieve my goal?
Thanks,
Noodle