Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Google search has instant search feature. While you are typing, it finds the pages. Apple.com search box. StackExchange ask question part finds similar questions while you are typing question title.

I am building a collection of web applications in same system. I will add a general search functionality to search through storage of all web applications. But thinking that tables will have records of thousands of users, and that searching will be done for all applications, that can cost too much server power.

I consider caching, though it is like creating all database tables in a folder or memory with same information. I don't see any benefit from this approach.

How are businesses are building this kind of feature in products professionally? Is there any special technique, or can caching really solve it?

P.S. I am using PHP with MySQL.

share|improve this question
    
I think SO uses very heavy caching for this. Google has a custom proprietary database so they are probably not a good case to compare against. –  JNK Sep 14 '12 at 19:57
    
are you looking for something like this? –  Nehal Dattani Sep 27 '12 at 18:47
    
No. That is only auto complete. Without having the data quickly, auto complete doesn't mean anything. Its time will come though not now. –  tcak Sep 28 '12 at 5:27
add comment

1 Answer 1

up vote 1 down vote accepted

If you're searching documents, a text engine like solr could be your friend. Combine that with ajax for real-time document discovery.

share|improve this answer
    
I think this is the answer. Thanks. –  tcak Nov 6 '12 at 6:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.