[thelist] [mysql] optimising query OR alternative to regexp?

Joshua Olson joshua at waetech.com
Tue Feb 26 17:16:20 CST 2008


> -----Original Message-----
> From: Paul Bennett
> Sent: Tuesday, February 26, 2008 5:46 PM
> 
> Hi all,
> 
> * db table with 100,000+ rows
> * one 'name' field in the format 'lastname, first names'

Hi Paul,

Encoding data into a field (as you have done with the name column) lends
itself to this sort of inefficiency.  I'd be very tempted to create columns
specifically for first name(s) and last name.  Then you should be able to
simplify your query and possibly eliminate the regex.

Joshua

<><><><><><><><><><>
Joshua L. Olson
WAE Technologies, Inc.
Augusta, Georgia Web Design
http://www.waetech.com/
Phone: 706.210.0168
Fax: 707.988.0168
Private Enterprise Number: 28752

Portfolio:
http://www.waetech.com/design/portfolio/

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/ 



More information about the thelist mailing list