Url Rewriting

Hey All,

I'm working on a new site that contains about 12500 products, 550 categories, 260 manufacturers which gives me a grand total of around 13000 give or take url aliases.

This is KILLING my site and I'm on a dedicated cloud server.

I've tried everything I can think of, caching aliases in both file and memcached, I completely rewrote the routing, moving the rewriting into the Url class to save having to access another object, I've even added all the url_alias rows to the session, and nothing is working.

I know this is the problem because when I turn off config_seo_url the site loads fairly quickly.

Does anyone have ANY ideas at all on how to make this faster. I'm not worried about rewriting core files as my code is extremely modified already so that's not an issue.

But I need to get this resolved ASAP.

Thanks so much.

its not the URL alias that is your problem its the product counts that kills the site

I have 12000 items too, and since I have disabled the product count for categories, my site works good

I don't think seo url will kill your site that easily. I have seen people with over hundreds of thousands of products without an issue. You might want to look at caching data, and ensure that there's no issue on your server side (I doubt so).

First, add index to your url_alias table.

I don't use url_aliases in opencart but I think you can do some optimalization like selecting url_alias with selecting category info etc.
If you don't know what to do, send me pm.