Rewrite lookup via MySQL table

[Michael Shadle]

You are a crazy, crazy guy agentzh! :)

On Mon, Aug 23, 2010 at 8:32 PM, agentzh <agentzh at gmail.com> wrote:

>> 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.

You could also whip up a quick little PHP script to do the
pre-processing for you, not bootstrapping Magento, but simply db
querying, and add memcache or apc or another caching mechanism,
without having to go this deep into development modules and having to
compile a bunch of external modules to get this to work :)