One side of the gathering time

The day before yesterday a few classmates to gather time to participate in the written test. Would have tried to hold the mentality, the results of the next day received a notice. The students who went with them said they had not received the question.

Monday I 10::10 to the Chinese laborers Grand Hotel, I was 10:30 points that batch, signed well after the patient in the seat and so on. The results were 11:15 minutes before my name was called. Just good to the front desk to ask if I did not hear (in fact, the intention is to urge a reminder), the staff said will check a check, let me go outside to wait a second, urge it really played the effect, after a few minutes there are staff called my name.

Go inside. The interviewer didn't let himself introduce himself, so he went straight to the subject. He opened the Baidu page with his mobile phone. Enter search keyword, along with the input of keyword, there is a drop-down list below to show the pre-measured search keyword, for example: Enter Guangzhou, the drop-down list will show Guangzhou University, Guangzhou Sea heart sand and so on. Ask what data structure is used to implement this function. At that time I froze a Leng, one to ask so advanced questions, I think I would like to say I will use a dictionary tree to achieve, then I roughly describe the dictionary tree and its advantages.

It felt that the narrative was not very good at the time, and that the right approach should be to describe the narrative. With paper and pen-specific description, this will deepen the impression of the interviewer, but also can prove that you really understand and not smattering half a bucket of water.

The interviewer asked the second question: now there are 15w of users connected to your server, ask the server how to deal with the user information sent and accepted.

I'm going to talk to the interviewer about socket programming. The interviewer interrupted me when I said you were talking about a user. Existing 15w users, how to solve.

I said: Use multiple threads. Each thread processes a user's request.

Interviewer: 15w user connections are loaded into memory. Can you? I said: If the memory is not enough, you can consider more than one server, and then according to the user's IP address range divided into multiple servers for processing. Interviewer: Now if there is only one server. A thread, how to handle it. All right, you win. Just a good answer does not know how to deal with, and let the interviewer answer how to deal with: The user's IP address and port to save the user to the server-initiated request to join the message queue. Multiple threads are used to process messages in Message Queuing (returned to the user based on the saved User IP and port).

The third problem: two administrators to access the database staff wages, if the salary is less than 3000 plus 300 wages. Requires writing out SQL statements.

Database did not learn, and do not understand. Interviewer: The main question is how to prevent two of people from visiting the data at the same time and making changes to the data at the same time.

I just remember to lock the data, as for the lock statement I forgot.

Then the interviewer asked two written tests on the choice of questions, said asked, asked me what I want to ask him, the whole process is more than 10 minutes, I knew the end.

One side of the gathering time