Jacob,
Don't worry about storing the leading the zeroes. Just left pad the
subscriber column to be 4 digits on output and you should be golden. MySQL
has a function just to generate left-padded numbers:
LPAD(subscriber,4,'0')
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
'Jacob Elder '
<[EMAIL PROTECTED]> To: "'''[EMAIL PROTECTED] '
' '" <[EMAIL PROTECTED]>
cc:
05/18/2004 04:05 Fax to:
PM Subject: Re: Simple table, 1.7 million
rows, very slow SELECTs
On Tue 18 May 02004 at 02:48:45PM -0500, Victor Pendleton wrote:
> In this case creating separate columns and making the values integers as
> oppesed to varchar will increase your query speed.
Okay, I'll give that a try. How do I set up my column types so that a
leading 0 won't be stripped off?
>
> -----Original Message-----
> From: Jacob Elder
> To: Victor Pendleton
> Cc: '[EMAIL PROTECTED] '; ''[EMAIL PROTECTED] ' '
> Sent: 5/18/04 2:11 PM
> Subject: Re: Simple table, 1.7 million rows, very slow SELECTs
>
> On Tue 18 May 02004 at 02:03:55PM -0500, Victor Pendleton wrote:
> > From this explain plan it appears a full table scan will be done. What
> is
> > the cardinality of this index?
> >
>
> Actually, they are phone numbers. I wasn't sure how this list would feel
> about this but I am wring a National Do-Not-Call Registry complaince
> tool
> for internal use at my company. We are a real estate agency, not
> telemarketers. We don't make a ton of cold calls but we don't want to
> get
> sued either.
>
> My table contains all do-not-call entries in Massachusetts. They are
> inserted in numeric order. Would it be faster if I broke it into columns
> for
> area code, exchange, and subscriber?
>
> --
> Jacob Elder
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
Jacob Elder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
