Simple SEO URL (OLD version) [support thread]

[yellow1912]

Right now, to build a category tree name with x cats for the FIRST time the mod has to query database x times. Even though this is done only ONCE, it is not efficient.
I should either try to make use of the name already retrieved in files, or use just 1 query. There is a a problem with trying to use 1 single query string tho, how should we select....in() yet still make the category names in the exact order.

[skaimauve]

Right now, to build a category tree name with x cats for the FIRST time the mod has to query database x times. Even though this is done only ONCE, it is not efficient.

My take on this is:
1. it is done once, therefore it is efficient, considering
2. it is looping though simple queries, therefore less prone to bugs

If someone has a site with x cats, where x is large, they should have the power to run these Simple SEO URL queries, cause the rest of ZenCart will require a lot of power anyway.

And again, if this is Simple SEO URL, we should have relatively compact code.

[yellow1912]

Thanks skaimauve, I thought so as well.

Also, I have made minor changes to the code, previously the content in files are stored like this:
example: c-name1-name2-19_20

From now on, we will simply store the names only: name1-name2

This allows us to re-use the names if we ever need to.