Is every URL you store going to be unique? If not, then will every URL+title combination be unique?
What I’m getting at is that, while every table should have an index, that index doesn’t _need_ to be artificial. “Natural” indexes are preferable, in fact, while also bringing the performance benefits @CrocoDillon mentioned.
**If** every URL+title combination will be unique, do `PRIMARY KEY( url,title )` and drop the `id` column.
You _might_ want to index the `title` column (separately) also, if you ever plan on searching by title without the URL.
Otherwise, **if** every URL will be unique, do `PRIMARY KEY( url )` and drop the `id` column.
You _might_ want to index the `title` column also, if you ever plan on searching by title.
Every `URL` and `Title` will be unique. The only way that they wouldn’t be is if I read the same article (title) from the same website (url) continuously. But Readability does not allow duplicate articles so that would be impossible.
I don’t ever plan on using any of the data to be searched. I only plan to list it as shown here.
I “plateaued” for a long time with SQL. Like, _five years_ of mediocre SELECT statements and not much else. It’s only in the last six months, really, that I’ve had an explosion of understanding… and I still have a long ways to go.