SEF links + router.php + slow website

Hi Eshop support team,

this is not really a bug, but it is an issue, that will become very serious as soon as the eshop products grows to a higher number.

The router.php for SEF links uses md5 database storage to translate links, but this is kinda not efficiant, because the database table grows with the number of products/categories/manufatures - that's logical.

Our Eshop has "only" 2000 products and all items have not been visited yet, but the db table for urls has already more than 20 000 entries.

1) The number of entries would not be that a big problem, but the problem is, that every link has to be looked up in this table => TONS of loading time. If you don't have the site cached, the loading time takes for even one product around 8 seconds (on a invdividual server) and loading a category takes up to 15 seconds. And if you let the category show 100 products at the same time, you wait nearly 3 minutes!!!

Those times are really very long comparing to other components...

2) Other problem is, that the md5 encoding is not bulletproof for duplicating items. You see, lot of links appear in the table more than 2 times and some up to 6 times. (see attached image) This makes the db usage even heavier.

Please, look at this Eshop support team!

Thanks a lot for the great work!
The ot

Hello Tom,

I and our teams have been testing more cases with a very big test database of EShop to check on this. We will give you the update once we find anything related to this.

Sincerely, Giang

If you can solve this, then I can really say, that your component is awesome!

The sef urls are so far the biggest drawback of it.

Hi!

Any progress on this topic?