On Tuesday 13 August 2002 06:50 pm, Steinar Kolnes wrote:
Just create indexes on first and last, that should improve the speed of your
query drastically. It will of course be a BIG index. You might experiment
with only making the width of the index small, like maybe 8 or 10 characters
might
Hi there,
I have to make a large 6.5 million names and numbers database in MySql(maybe
not so
large for some of you). Yet it is very simple, here is my sql file:
create table subscriber
(
id bigint unsigned not null auto_increment primary key,
subscr_id
You need an index, it should drastically cut the query time. See:
http://www.mysql.com/doc/en/CREATE_INDEX.html#IDX1466
Mike Hillyer
Dynamergy Software
-Original Message-
From: Steinar Kolnes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 4:50 PM
To: Mysql List
Subject: Need
In the last episode (Aug 14), Steinar Kolnes said:
I have to make a large 6.5 million names and numbers database in
MySql(maybe not so large for some of you). Yet it is very simple,
here is my sql file:
create table subscriber
(
id bigint unsigned not null auto_increment
Thanks to Dan Nelson and Mike Hillyer,
Indexing brought the search downto 2.03 sec compared to 3 min and 16 sec !
Thanks again.
Rgs
Steinar Kolnes
-Opprinnelig melding-
Fra: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sendt: August 14, 2002 1:14 AM
Til: Steinar Kolnes
Kopi: Mysql List
Emne:
