[TriLUG] OT: DBMS performance

[Andrew C. Oliver]

1.5MB of ram...that is a pretty small machine :-)

Steve Litt wrote:
> 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/
>   


-- 
>From Windows/Exchange to Linux/Meldware
Buni Meldware Communication Suite
Email, Calendaring, ease of configuration/administration
http://buni.org