CAn any help me , I think at least 5 million people are using twitter ,so 5million record in database . How fast twitter checking user availability within typing password..... can any one teach with script thanks in advance
A fast server with an optimized database can be fast, even with so many records. Consider this: if twitter has instead of 1 table with 5 million records, 26 tables with 200k records each (one table for each letter of the alphabet) and a user is added to the table corresponding to the first letter of the name. This is pretty simple to do and it makes searching 26 times faster. That's just an example of how you can cut query times. I'm sure they use much more complex algorithms.
that was great thank you kingsoflegend but can anyone explain that with php and mysql that may help me and other new learners thanks in advance
Its not just PHP and MySQL. You also need Ajax. If you don't understand the technologies required, then I don't think you will find it very easy.
http://www.9lessons.info/2008/12/twitter-used-jquery-plug-in.html check this tutorial ,i can understand the technologies .... but can anyone explain the code with 26 tables!!!! just like how kingsoflegend said... thank you