# Best autocompletion database index

**URL:** <https://www.ruby-forum.com/t/best-autocompletion-database-index/113963>\
**Category:** Rails\
**Created:** [September 6, 2007, 6:31pm UTC](https://www.ruby-forum.com/t/best-autocompletion-database-index/113963 "2007-09-06T18:31:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![charlie\_caroff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/a587f6/32.png) [@charlie\_caroff](https://www.ruby-forum.com/u/charlie_caroff)\
**Post date:** [September 6, 2007, 6:31pm UTC](https://www.ruby-forum.com/t/best-autocompletion-database-index/113963/1 "2007-09-06T18:31:35Z")

</div>

Hi,

I made an autocomplete search field, which suggests searches that are  
already in the database, like Google does with its Google toolbar.

I run mysql. Is there an indexing or other method that makes the  
database lookup fastest?

Charlie

---

<div class="post-metadata">

**Author:** ![charlie\_caroff](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/a587f6/32.png) [@charlie\_caroff](https://www.ruby-forum.com/u/charlie_caroff)\
**Post date:** [September 10, 2007, 9:23am UTC](https://www.ruby-forum.com/t/best-autocompletion-database-index/113963/2 "2007-09-10T09:23:10Z")

</div>

CAn i suggest index\_by or acts\_as \_ferret for the same  
i hope

On 9/6/07, charlie caroff [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Charlie
> 
> >

–  
Piyush  
09916133729

> **[Three finger salute](http://ctrlshiftesc.blogspot.com/)**
>
> I think, therefore I Am...said Descartes! 
> 
> I Am, therefore I will think...said Ayn Rand! 
> 
> I think I Am, therefore I think I am thinking...says The Common Man!!!