How does Quora render content from URL slug without any number and purely varchar?

I know we can run site with purely varchar (clean slug) as url, but doesnt that put heavy load on the database? What kind of technology is quora using to render content quickly even without having any ID in the URL?

Even Hashnode uses some hash in the URL slug to work it out as ID.