|
Posted by Toby Inkster on 05/03/06 11:05
Ben Holness wrote:
> 3. Product code is a varchar in the DB
Do this. If the column is indexed, this should be very fast.
The only queries that will slow things down are LIKE queries where the
first part of the pattern to match is a wild card.
But for a product code, it's likely you'll only be interested in exact
matches, so that shouldn't be a problem.
--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact
Navigation:
[Reply to this message]
|