yes i search on phone number. it's indexed(7) and the format of the phone
data is (XX) XXXX XXXX.
is there anyway this could be optimized. I will eventually remove the spaces
and the first 4 characters from the input data and reload it in
Kris Amy
-----Original Message-----
From: Don Read <[EMAIL PROTECTED]>
To: Kris Amy <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, 29 June 2001 2:07
Subject: RE: Query Slowness
>
>On 29-Jun-01 Kris Amy wrote:
>> i have a database and a table:-
>>
>> mysql> describe phone;
>> +-------+----------+------+-----+---------+-------+
>>| Field | Type | Null | Key | Default | Extra |
>> +-------+----------+------+-----+---------+-------+
>>| name | blob | | | | |
>>| add1 | blob | | | | |
>>| add2 | blob | YES | | NULL | |
>>| phone | tinyblob | | MUL | | |
>> +-------+----------+------+-----+---------+-------+
>> 4 rows in set (0.03 sec)
>>
>> mysql>
>>
>> The only problem is that it takes anywhere between 10seconds-1 minute to
>> search the database. there is ~8.5 million records in it though.
>>
>> Anyone know howto speed this up?
>
>What do you search on, the phone number ? that what's indexed.
>Great for a reverse-directory, not so good for a name-> number query.
>
>Regards,
>--
>Don Read [EMAIL PROTECTED]
>-- It's always darkest before the dawn. So if you are going to
> steal the neighbor's newspaper, that's the time to do it.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
