[TriLUG] OT: DBMS performance

[Steve Litt]

Hi all,

From a MySQL or Postgres DBMS on a commodity machine (Athlon XP2600+ with 
1.5MB RAM) that's not being used for anything else, running (Mandriva 2007) 
Linux, how fast should one be able to retrieve 5000 matching records out of 
3.5 million total records? The matches match the field exactly (including 
capitalization).

How long if the field being searched is indexed?

How long if the field being searched is not indexed nor a primary key?


Obviously the answers I'm looking for are very approximate. Would 5 seconds be 
good if it's indexed? If it's not indexed? 

How bout 1 second?

Thanks

SteveT

Steve Litt
Author: Universal Troubleshooting Process books and courseware
http://www.troubleshooters.com/