Welcome! Log In Create A New Profile

Advanced

Re: Rewrite lookup via MySQL table

August 23, 2010 11:44PM
You are a crazy, crazy guy agentzh! :)

On Mon, Aug 23, 2010 at 8:32 PM, agentzh <agentzh@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 :)

_______________________________________________
nginx mailing list
nginx@nginx.org
http://nginx.org/mailman/listinfo/nginx
Subject Author Posted

Rewrite lookup via MySQL table

btafoya August 23, 2010 08:22PM

Re: Rewrite lookup via MySQL table

mike August 23, 2010 08:28PM

Re: Rewrite lookup via MySQL table

agentzh August 23, 2010 10:20PM

Re: Rewrite lookup via MySQL table

Piotr Sikora August 23, 2010 08:46PM

Re: Rewrite lookup via MySQL table

agentzh August 23, 2010 11:40PM

Re: Rewrite lookup via MySQL table

mike August 23, 2010 11:44PM

Re: Rewrite lookup via MySQL table

agentzh August 24, 2010 12:00AM

Re: Rewrite lookup via MySQL table

btafoya August 24, 2010 12:03AM

Re: Rewrite lookup via MySQL table

mike August 24, 2010 12:16AM

Re: Rewrite lookup via MySQL table

agentzh August 23, 2010 11:46PM

Re: Rewrite lookup via MySQL table

btafoya August 24, 2010 12:05AM

Re: Rewrite lookup via MySQL table

agentzh August 24, 2010 12:06AM

Re: Rewrite lookup via MySQL table

agentzh August 25, 2010 01:54AM

Re: Rewrite lookup via MySQL table

relix August 28, 2010 08:54AM

Re: Rewrite lookup via MySQL table

agentzh August 29, 2010 11:26PM

Re: Rewrite lookup via MySQL table

bvidinli August 30, 2010 06:38AM

Re: Rewrite lookup via MySQL table

bvidinli August 30, 2010 06:38AM

Re: Rewrite lookup via MySQL table

relix August 30, 2010 09:04AM

Re: Rewrite lookup via MySQL table

btafoya August 24, 2010 02:27PM

Re: Rewrite lookup via MySQL table

btafoya August 24, 2010 02:41PM

Re: Rewrite lookup via MySQL table

mike August 25, 2010 01:14AM



Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 252
Record Number of Users: 8 on April 13, 2023
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready