List:General Discussion« Previous MessageNext Message »
From:Colin McKinnon Date:June 21 1999 10:27am
Subject:Re: improve speed and about Distributed Database
View as plain text  
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

Thread
improve speed and about Distributed Databasenagarindx puppetsworld21 Jun
  • Re: improve speed and about Distributed DatabaseColin McKinnon21 Jun