Suppose I have many data objects that include very many share very many identical strings (e.g. tags, URLs, "DEBUG"/"TRACE"/"INFO", etc...).
Which databases (if any) pool identical strings internally to prevent them from being copied many times?
Suppose I have many data objects that include very many share very many identical strings (e.g. tags, URLs, "DEBUG"/"TRACE"/"INFO", etc...).
Which databases (if any) pool identical strings internally to prevent them from being copied many times?
It's usually up to you to do that via normalisation. Have a table with unique URLs in it, and link to that by its ID.