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?
Kind Regards
Kris Amy
