Hypothetically, what is the speed difference in evaluating a WHERE clause using a number vs. a character? For instance:
- Select * WHERE key = “xyz”; vs.
- Select * WHERE key = 1234;
The context is this: I want to generate a unique email message to a user on my website every time a new row is placed in a database under that username. This message should have a link directly to a page that will display the data from this row, such as:
In order to keep this reasonably private, I want to generate a unique key as part of the row and include this in the URL sent in the email, such as:
I anticipate activity spikes, so making the verification as efficient as possible is important.