Keep in mind your personal growth after an interview is not as expected

I wanted to write a blog two months ago. I wanted to record the excitement and loss of the two interviews I shared with you, but I was afraid that such experiences would not be able to go to the classroom, so it has been until now, but after a period of time of thinking, I finally found some things to enrich myself and pay attention to. These days are regular and simple, insist and happy, and think, action. I am not bored for work, I am not working for work, I don't want to change jobs for no sense of gain, I'm so calm, that's good!

This log is roughly divided into the following outlines:

I. Interview experience

Ii. Personal reflection and awareness

3. Get a website by yourself

4. Difficult decisions were made between database selection

5. rewrite an open-source crawler project to include network Novels

6. Some experiences of using paie.net as an index tool

7. The indexing engine for a website goes online for one week and does not overwrite the website URL.

8. Regular database indexing and regular sitemap for websites

This article is a bit long, mainly about the experience of this period of time. The technologies involved are just a few points. The article on the specific implementation will be summarized later.

I. Interview experience

As early as February October, I got my leave and got back. I had the idea of changing jobs. It wasn't that the company had no prospects, that the leaders were not easy to get along with, or that my colleagues were unfriendly, instead, I wanted to change the environment inexplicably, So I updated my resume online and received HR calls from some companies, after some positive understanding and side inquiry, I replied to the two companies, first xineg.com and secondly Infosys, which involved professional ethics issues. I will not directly write down the pen questions related to the two companies, if you have accidentally disclosed the details you should not have disclosed, please forgive me for not being careful.

Singe network is an e-commerce company in the United States. It operates the newegg.cn Chinese Market in Shanghai and supports the newegg.com Project in the United States, the Department I want to interview is to support the newegg.com Project in the United States. It is more than ten minutes ahead of the agreed time to enter their office building. The front desk asked me to wait in the lobby and sit down for a few minutes, I watched the surrounding area, and there were a lot of conference rooms and beautiful sisters. They were preparing for a meeting and people were coming and going. This layer should be mainly from the marketing department and the sales department, like a market, talking about contracts, when I called the phone, the whole reception hall was not so quiet and the cost was not so long. After a while, I was taken to the next layer by a mm from the personnel department, after some simple explanations, I brought me into a conference room and gave me a test paper. This is a test and I am used to this process, I probably flipped through the number of pages and asked her how long it took to complete the question. She said that the question was divided into two parts: a non-skill question, similar to the "countless balls with black, yellow, and blue colors in a bag, you can ask at least how many balls in the same color to ensure that there are two balls in the same color." The other is a skill question, it is a little more difficult than some conceptual questions and requires a small . I have a habit of writing a test: first, determine the time, and second, first pass all the questions, and probably determine the time required to finish all the questions, if the question is abnormal and cannot be answered, or the question can be less than 60%, I will directly tell HR that I am not suitable and don't waste time on each other, then I leave with a bit of disdain. If the question is more satisfactory, I usually hand over the examination paper within half an hour to three minutes. The question arrangement is reasonable, well-defined levels, basic concepts, front-end JS, CSS, HTML, database, design, flow chart, and UML diagram, there are code logic and code elegance test questions, which involve a wide range of topics, and the number of questions is not large. The whole process is not done except for an SQL question, the other statements basically express the meaning. I didn't make the SQL question because I felt that I could not reach the intention of the author, it means that the results of two tables are identical. Check the different records of the two tables. At that time, I thought it was either an SQL statement with this memory syntax, otherwise, algorithms are involved. I have seen this SQL statement. If I use an algorithm to implement it, it is not an SQL statement, so I gave up.

Unexpectedly, at the interview stage, I came to a fat guy who looked very young, had glasses, and smiled. (I like it very much and I don't think it's a big sense of distance ), as I introduced myself, he looked at my test questions and asked some brief questions about some projects on my resume from time to time. I answered them easily, inadvertently, he said that his family belongs to Shandong province. I went to a university in Jinan, and both of them couldn't help but feel friendly. I asked him if he still had a steamed bread to eat garlic, he said that he is still used to eating rice. I said that I am used to eating steamed bread noodles instead. I think he grades my answers from time to time, he wrote comments after each piece of his interview card. He asked me some solutions for HTTP protocol, network security, and anti-ticket farming, so naturally, he smiled from time to time and made me feel relaxed. Finally, he said that he was ready to understand and asked me to wait, he asked his supervisor to meet him. In a short time, he came to a white-skinned person who looked like a leader. I briefly introduced myself and talked about my work experience, my project experience, my current work conditions, and I want to change jobs From time to time, he asked me several questions in English. I gave some cases and asked me how to solve the problem, if you are not familiar with this issue, you cannot understand it. He was very satisfied. He said that he was confident and did not shy away from his questions. He introduced me to the current department, the project, and finally asked me what I expected, finally, he said OK. He went to the personnel department to talk to me. In a short time, I came to a mm. While reading my resume, I said that I have been working for three years. Why do I want to change my job? I want to know more about e-commerce, accumulate more mature technologies, and find a more valuable job. She asked her how she expected such a high level of treatment after three years of work, if I say I pay for it, the greater the responsibility, the greater the return, I believe that I have the ability to request this treatment. She nodded silently and talked to me about the company's welfare, trade unions, insurance, provident fund, and weekend activities and entertainment projects. She asked me when I could get started as soon as possible, at that time, I thought it was a matter of fact. I nodded seriously and accepted the situation she introduced. Later I talked about the health check. I said the company's health check report two months ago was okay, she said no problem. She finally told me when she was about to leave. The Personnel Department will conduct an investigation into the new employees who are about to join the company. This is the same for every colleague, I said it doesn't matter. I will wait for your message. She said she will give me a notification within the week. In this way, the interview is over, and it will take more than two hours before and after, I was so happy that I went to the subway and went home to sleep. When I woke up, I told everyone I was familiar with. I thought it was a decision.

A week of waiting is suffering. What is depressing is that after such suffering is a lost result. It is indeed painful in the heart, after a week, I couldn't send an email to ask the personnel, but the personnel replied: Your interview result is: Waiting for talent. There is a feeling of being played.

After receiving the interview notification from Infosys, I came to the company with a few sureness and expectation. It was 10 minutes ahead of the agreed time. After I registered my badge with the security department, A person-in-person girl took me into a meeting room. After a short wait, she came to two interviewers. Both of them looked quite young, but they gave them a sense of sureness, I was influenced by two reliable people. I was wondering that I did not have a written test of my interview skills? From the question content, I guess one is responsible for technical planning and the other is responsible for career planning. Both of them are very friendly, and there is no ambition to give up on your question, when talking about a portal website I participated in, the interviewer suddenly became interested. Let me talk about the architecture, technology, deployment, and security issues used in it, performance problems occur along with each other. If necessary, I should also draw a picture on the blackboard, such as the deployment and business logic. Due to actual participation, the drawing is also handy and the logic is clear, later I asked some questions about the page lifecycle, HTTP protocol, page loading speed, and page User Experience Improvement. He nodded with a smile instead of asking any questions I answered, I also asked some questions about career planning, such as whether I had set a goal for myself within five years, what job I wanted to do, or whether I wanted to change the nature of my job, my answers to my career questions are generally more realistic and somewhat negative. I said that I didn't plan for myself, but I just wanted to do my own responsibilities, after doing what you should do, do what you want to do. Many things may be appropriate, Think too far, too tired. He asked me why I wanted to work in our company. I said that my understanding of the company is big companies and the world's top 500 companies. There will be more technological accumulation in such companies, with more normative accumulation and more excellent people, I want to be with excellent people, and I will also become better. After checking whether there are other things to understand, the two men asked me to wait for a while and then went out. After a while, the personnel mm who received me came in and brought me a paper, I said that you have passed the interview. If you have finished the examination and completed the examination, the question will be almost the same. I have a look at the two papers, both of which have the question on the front and back. They are all in English, I asked her how long it took. She said it was an hour. I probably browsed some questions. I went here. I don't have any fucking skill questions. They are all logical thinking questions, and they are still in English, however, most of them still know each other, so they calmed down and did it. About 10 minutes later, they wrote three or four questions. At this moment, they met mm and said with a sincere attitude, sorry, there was a misunderstanding in the communication just now. The interviewer said that your interview result is very OK and you don't have to answer questions. You passed the interview and waited for the personnel to communicate with you, I asked if it was the end of today. She said yes. The personnel will contact you next. Two days later, I received a call from the personnel. To tell the truth, I am a little nervous. I don't know why, I obviously felt a trembling voice on the phone. After a brief greeting, she said that your current situation (mainly three years of experience and poor English skills) may not be able to give you the necessary treatment (When filling in the personnel information, I asked how much the company's current salary system can work, and she said it would be 2 K less than your expectation. After a short thought, I said, considering that I still cannot accept the year-end bonus and the current situation of treatment at the end of the year, she said that you can measure it in all aspects and that you have come to the company to prove that you have done it, the treatment can be adjusted online. I cannot hear such empty talk. After I insist that I cannot accept it, she said she would try again to obtain the opinion of the competent authority to see if she could apply for it. I said yes, this is the end.

There will be no news afterwards. The two interviews were both well performed and the results were not as expected.

Ii. Personal reflection and awareness

These two interviews have the deepest impact on me, because they have all made me feel ups and downs and have nothing to lose. Sometimes bad things may not be bad, and my job is almost there now, state-owned enterprises have few things. They can listen to music at work and access the Internet. They are easy to use. After some self-comfort, I confirmed that I had to think about the job for years.

However, for me, I am most afraid of being idle, so I cannot concentrate on my thoughts. When I am idle, I will think about something that is not marginal. When I am idle, I will feel that I have no sense of value and will be forced to break down.

If you want to build a website on your own, you don't know what kind of website you have in mind at that moment. When you are normal, my colleagues will read novels, and I will also read novels, I also read pilong at the front-end time. I'm depressed that all VIP chapters will go to Baidu to search for free, but the ads for free novels are really a mess. At first glance, they are garbage stations, but now there are many free novel sites, so I think of targeted search. If I search for a novel on my website, I can search for dozens of free novel sites, by ranking by update speed, the reader will be able to find the website updated in the first time after watching the novel. This will make it much easier to read the novel. After confirming, the reader will start to collect information on the Internet, search for related things, clarify the ideas, and start to do it.

3. Get a website by yourself

After determining how to create a free novel website, you must first think about the domain name. What is the name of the website? I started to look for a friend who had known it before. He is a space domain name proxy, I know that Domain Name Record-filing is troublesome now, so I asked him if he could help me easily record the domain name. He sent me a document about the materials needed for Domain Name Record-filing, if you don't know what to do, you don't want to do it. It's a lot of trouble to prepare so many materials. Remember to create a blog in college, I bought a Domain Name and entered some information on the Internet. I passed the review in a week. It is a headache to have copies of messy certificates. In the rogue, he offered a simple and direct offer to find the old domain name that someone else has already filed for record but is not using. I think this is a good idea, so he gave me a batch of domain names in this situation. I looked at the domain name and wanted a name. I used the sogou Input Method to print the Chinese characters of the domain name to see what it was, after a general view, I read a domain name (tiyma.com) which is still relatively short. The Chinese character that I typed with sogou is: The Experience code, which is highlighted in my heart, so I settled the domain name, "experience code novel website may be the best free novel Website", and I gave it the title.

4. A difficult decision was made between database selection.

Oracle has been used by many projects, followed by mssql2000 and mssql2005. Some projects use MySQL, so Oracle is a little familiar with it, but for me this understanding, and the use of the level of personnel, in addition to some simple query statement optimization, index optimization, T-SQL writing, stored procedure writing, database Engine algorithms are completely unknown. In terms of operation, MSSQL is basically interface-oriented and straightforward. It is very easy to back up, restore, synchronize data, and subscribe to distributed data, in terms of applications, Oracle is a slightly larger enterprise-level solution. It has high requirements on the environment and accounts for more than 400 mb of memory when the Oracle service is started, so if you choose MSSQL and Oracle, I will not hesitate to select the MSSQL database at the application level, but because of the addition of MySQL, this is because the novel website inserts data into the database concurrently when collecting the novel chapter directories. In a project, data is frequently read from the database, causing database occupation. The system memory keeps increasing, and after all the operations on the database are stopped, the system memory occupied by the database still does not drop, which is hard for me to understand, in order to determine which one is used in MySQL and MSSQL, I did a test. My colleague started 1000 threads to write data to MySQL and MSSQL in an hour, during the test, it was found that MySQL had not increased since it reached a peak value after occupying more than 420 MB of memory, but MSSQL had been rising since it reached more than 700 mb, with this data, I have the answer in my mind. I chose the MySQL database without thinking about it.

You can download the MySQL database directly from the official MySQL Website:

Http://dev.mysql.com/get/Downloads/MySQLInstaller/mysql-installer-5.5.17.0.msi/from/http://gd.tuwien.ac.at/db/mysql/

Database operation tools can be downloaded from the official website MySQL workbench

Http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-gpl-5.2.36-win32.msi/from/http://gd.tuwien.ac.at/db/mysql/

MySQL database installation will encounter some problems for the first time, such as changing the data file storage path, which is installed on the C drive by default, and the configuration of some environment variables. after the INI file, the MySQL service cannot be started and uninstalled repeatedly. After repeated installation, the database environment is set up.

5. rewrite an open-source crawler project to include network Novels

I read a spider crawler program written by a foreigner from the Internet. It uses the socket download URL, loads the URL address in the queue, and downloads the source code. You can download it here:

Http://www.codeproject.com/KB/IP/Crawler.aspx

I think I can use this project as a tool to collect novels. I analyzed the structure of the novel website, which is roughly the list page, novel introduction page, and Chapter list page, chapter content page (I will not include this page, otherwise, there will be thousands of chapters in a novel, one chapter is 15 K, and there is no server resource to store ), therefore, I need to parse the chapter list page and get the novel information (only the title of the novel can be obtained). I can judge from the database whether the novel already has the site. If yes, return to the chapter list address of the novel. If not, include the introduction page of the novel, parse the novel information, obtain the address of the novel chapter list, then include the novel chapter list page, and parse the title of the novel chapter, save the title of the novel. Below is a simple logical diagram:

 

For saving chapters, a novel may have thousands of chapters. How can we incrementally store the chapter information? If a novel does not insert a chapter and determines whether the chapter exists in the table, the speed will be very slow. For the novel, this record contains 100 chapters and has been saved to the database. The next record may contain 105 chapters, that is to say, five chapters have been updated, so we only need to get the name of the last chapter updated by the novel before insertion, then, find out the five updated chapters from the 105 chapters and insert them directly into the database, which is faster. MySQL has a batch insert method, which is faster.

I have stored the chapters of a novel in sub-tables. A novel site is a table for convenience in future operations, create the novel chapter table of the site automatically without adding a site configuration. The following information is required for adding novel sites:

Let's not talk about the details. Let's take a look at the effect:

Now there are more than novels on one site, which are basically included in two threads in one night. Therefore, novel updates can be recorded in a timely manner.

6. Some experiences of using paie.net as an index tool

To make it easier and faster for readers to search for novels they want to read, I use paie.net as an index tool to create data indexes. Readers can create data indexes based on novel names, author names, and level-1 categories, second-level classification is used to retrieve novel information. I think this is a good choice.

Articles on introduction and use of paie.net can be found in the blog site. Many garden friends have written in great detail. The SVN address of paiet.net:

Https://svn.apache.org/repos/asf/lucene/lucene.net/tags/

If you have SVN installed, you can directly check the source code or directly use its DLL. Currently. the highest version of net is 2.9.2. At first, the idea was real-time indexing. That is, every time a novel was included, the index file was produced using the interface provided by e.net, and the index was also updated when a novel was updated, however, there are two problems in actual operations: one is that there is indeed an index addition method in version 2.9.2, but a single index addition method will be slow. I tried to update the index many times, if the index file is not successfully created, the index file will be destroyed. Therefore, we will consider a regular full-database index method. This will change the index time based on the size of the data volume, however, the scheduled index time is generally performed at night, so it has little impact. Check out my scheduled index tool:

I make it a service for regular execution, or you can manually execute it to produce index actions.

7. The indexing engine for a website goes online for one week and does not overwrite the website URL.

A week after the website was launched, we had the first loyal reader who was a friend in QQ. We didn't know it because it was a technology, I have provided a lot of good suggestions. I would like to thank the students of milk sugar for their support. From the first week of release, Baidu is not included, Google is rarely included, and Soso is a little bit more, because there are many novel chapters, it means crawlers are afraid of having to have thousands of addresses for a novel, but the number of addresses indexed by several search engines cannot exceed one thousand. I wonder if the chapter address is not included, and whether it is the reason for the Address URL, so I thought of using the rewrite method to see if it worked.

Http://www.tiyma.com/book.aspx? Siteid = 5 & bookid = 23490 rewrite the novel address

Http://www.tiyma.com/book/5/23490/ such a form, so crawlers should treat it as a new address to include, not because it is the same file name and not included. After the transformation, Soso's indexing volume increased by more than 1000 on the first night of its launch, and it felt quite rewarding.

For details about the rewrite method, refer to the article in the garden:

Http://www.cnblogs.com/notus/archive/2007/03/13/673222.html

Because I am an overwrite of the Post-shadow code, you need to configure the site on IIS to check whether the URL file does not exist. The specific configuration steps are as follows: the ing of the application with the wildcard character "Site", "Home Directory", and "configuration" are displayed. In the displayed dialog box, select c: \ windows \ Microsoft. net \ framework \ v2.0.50727 \ aspnet_isapi.dll, remove the "check box for checking whether the file exists" below, and click OK.

8. Regular database indexing and regular sitemap for websites

In order to allow the Web Crawler to collect the website novel information, a corresponding tool was developed to produce site maps, producing 50 site maps at a time. For my site:

Http://www.tiyma.com/sitemap/sitemap.xml

......

Http://www.tiyma.com/sitemap/sitemap50.xml

Click it to submit a site map to google, and compile the corresponding robots.txt file to inform crawlers of the Indexing Rules,

Http: // www.tiyma.com/robots.txt is my indexing rule. The content is simple and can be produced based on Google webmaster tools.

 

It is the first time to write such a long article in one breath. More technical implementations will be written in later articles. It's too late. Let's just end it in a hurry.