Rewrite lookup via MySQL table
nginx-forum at nginx.us
Tue Aug 24 04:22:32 MSD 2010
Any chance I can use a MySQL database table to do a lookup to return the
url to rewrite to?
Let me explain the situation first...
Magento utilizes rewrite rules heavily but does the majority of the
rewrite within the Front controller. The problem is that it is VERY
in-efficient and a store with more than 10,000 products is severely
delay. But, all information is referenced in a table 'core_url_rewrite'
so my though it so do the lookup first in Nginx and hand off to Magento
with the non-seo url.
Any idea/though would be GREATLY appreciated.
Two dedicated servers, one web, one db, both with ridiculous amounts of
memory and high speed drives.
Posted at Nginx Forum: http://forum.nginx.org/read.php?2,122977,122977#msg-122977
More information about the nginx