Welcome! Log In Create A New Profile

Advanced

Rewrite lookup via MySQL table

August 23, 2010 08:22PM
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.

Brian Tafoya
Prema Solutions
www.premasolutions.com


Current environment:

Two dedicated servers, one web, one db, both with ridiculous amounts of memory and high speed drives.

nginx
php-fpm
php 5.3.3
apc
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: 94
Record Number of Users: 6 on February 13, 2018
Record Number of Guests: 421 on December 02, 2018
Powered by nginx      Powered by FreeBSD      PHP Powered      Powered by MariaDB      ipv6 ready