I am trying to work out what would be the fastest way to compare user data which has been entered into a form with user data that is already stored in the database.
My plan was to pull all details of a single column into an array i.e. email, then compare them with the value entered, but I think that will get vary slow as the database grows.
My second idea was to use Zend_validate::is($email,'email') but that throws the error 'Validate class not found from basename'. The only information I can find on this error is references to a bug.
My question is: When comparing value from a form and database what would produce the quickest results?
This is part of a custom module (my first one)
I am trying to avoid duplications within my table
The module will provide me with a list of people who are not members but want information specific events