English 中文(简体)
How are mobile service provider databases so fast?
原标题:

i was wondering on how these databases
which have over millions of records and
millions of lookups per second soo fast.
how are they optimised?
are there any special servers hosting these databases? how are they scaled?

最佳回答

large applications are scaled out across multiple servers. Your ID is usually hashed into a bucket of some finite number (ex. 50) and these 50 server can handle 1,000 s of requests per second. Usage is presumed to be split fairly evenly over all 50 servers. Backup and recovery are a bit more complicated in that "some" users may lose data while others won t.

问题回答

暂无回答




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签