Re: improve speed and about Distributed Database

[Colin McKinnon]

At 22:48 20/06/99 -0400, nagarindx puppetsworld <ngrxmail@stripped> wrote:
>Hi...
>I have a table (name 'resume') with 25 columns with 300,000 records.Record
>size is about  1 kbyte."HN" is a primary key. And I use SQL like this
>"SELECT name FROM resume WHERE hn='1234567'".It takes about 1 minute 24
>seconds....is it too slow???
<snip>
Does seem quite slow (assuming you've got a reasonable spec machine not
under heavy load).
Check it's using the index with EXPLAIN.

Colin