Question about performance, which is better?

Hi, i’ve to make a permalink and i’ve to choose about two options.

  • The first one is to make the permalink id-name and save it in the db
    and then search the product using the permalink
  • The second one is to make everytime the link with a concatenation of
    strings and then take from the url just the id and search in the db the
    product by id

One is space consuming, the db will grow rapidly (there are really a lot
of product), on the other hand there is a cpu clock consuming to make
the url and then take only the id (so a concatenation and then a
substring)

Which do you think is better about performance? Do you suggest something
else?

Thanks

Mix M. wrote:

Hi, i’ve to make a permalink and i’ve to choose about two options.

  • The first one is to make the permalink id-name and save it in the db
    and then search the product using the permalink
  • The second one is to make everytime the link with a concatenation of
    strings and then take from the url just the id and search in the db the
    product by id

One is space consuming, the db will grow rapidly (there are really a lot
of product), on the other hand there is a cpu clock consuming to make
the url and then take only the id (so a concatenation and then a
substring)

Which do you think is better about performance? Do you suggest something
else?

Thanks

why would you need a permalink for at product???

this permanlink-craze is getting out of hand…do you think the users
are more able to remember

http://myshop.com/product/12345

than

http://myshop.com/apple-macbook-white-with2g-of-ram

???

Mikkel

Mikkel B. wrote:

why would you need a permalink for at product???

search engines ? nicer?

this permanlink-craze is getting out of hand…do you think the users
are more able to remember

http://myshop.com/product/12345

than

http://myshop.com/apple-macbook-white-with2g-of-ram

actually i don’t think that a user remember the id, he add it in his
bookmarks or he remember the domain, but all the url…i don’t think
so… anyway the second explain better than the first, don’t you think?