# Speed on 4M query

**URL:** <https://forums.percona.com/t/speed-on-4m-query/620>\
**Category:** Other MySQL® Questions\
**Created:** [February 4, 2008, 10:58pm UTC](https://forums.percona.com/t/speed-on-4m-query/620 "2008-02-04T22:58:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zacher](https://avatars.discourse-cdn.com/v4/letter/z/85e7bf/32.png) [@zacher](https://forums.percona.com/u/zacher)\
**Post date:** [February 4, 2008, 10:58pm UTC](https://forums.percona.com/t/speed-on-4m-query/620/1 "2008-02-04T22:58:00Z")

</div>

If I have optimal server configuration and decent system hardware specs(dual quad core, 8G ram, 150mb/s read times) How long can I expect to wait to query a column with 4 millions rows(20 chars per row).

---

<div class="post-metadata">

**Author:** ![sterin](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@sterin](https://forums.percona.com/u/sterin)\
**Post date:** [February 5, 2008, 4:09pm UTC](https://forums.percona.com/t/speed-on-4m-query/620/2 "2008-02-05T16:09:53Z")

</div>

Do you mean without using indexes or?