Best way to retrieve TOP 50 values from the choicesInsert into … values ( SELECT … FROM … )Is DateTime.Now the best way to measure a function's performance?What is the best way to paginate results in SQL ServerBest way to reverse a stringBest way to store password in databasebest way to search data-base table for user input keywords?What's the best way to convert a number to a string in JavaScript?Fastest way to check if a value exist in a listQuery time analytics with Solr faceting and pivoting and log file dataKeyword Search in microservices based architecture

Is there a RAID 0 Equivalent for RAM?

Terse Method to Swap Lowest for Highest?

How can I write humor as character trait?

Keeping a ball lost forever

How does the math work for Perception checks?

How does a computer interpret real numbers?

How could a planet have erratic days?

Biological Blimps: Propulsion

Is there an injective, monotonically increasing, strictly concave function from the reals, to the reals?

Can disgust be a key component of horror?

Fear of getting stuck on one programming language / technology that is not used in my country

Can a Canadian Travel to the USA twice, less than 180 days each time?

How to explain what's wrong with this application of the chain rule?

When were female captains banned from Starfleet?

Why is so much work done on numerical verification of the Riemann Hypothesis?

Why is the "ls" command showing permissions of files in a FAT32 partition?

Non-trope happy ending?

What should you do when eye contact makes your subordinate uncomfortable?

Creepy dinosaur pc game identification

Why is it that I can sometimes guess the next note?

What happens if you are holding an Iron Flask with a demon inside and walk into an Antimagic Field?

Quoting Keynes in a lecture

Calculating total slots

What if a revenant (monster) gains fire resistance?



Best way to retrieve TOP 50 values from the choices


Insert into … values ( SELECT … FROM … )Is DateTime.Now the best way to measure a function's performance?What is the best way to paginate results in SQL ServerBest way to reverse a stringBest way to store password in databasebest way to search data-base table for user input keywords?What's the best way to convert a number to a string in JavaScript?Fastest way to check if a value exist in a listQuery time analytics with Solr faceting and pivoting and log file dataKeyword Search in microservices based architecture













0















Question.



Let's say you work for search engine company and you would like to see TOP 50 of most-searched keywords of yesterday. If access logs are distributed over thousands of server, what would be the best way to achieve your goal?



1) Redis shows the great performance in this case. Creating a program that checks searched counts by search keyword, let it read all distributed logs, and find the top 50 by using Redis command would be the way.



2) RDS is the best in this case. Create a program that checks searched counts by search keyword and find top 50 by SQL command.



3) Search Engine(ElsaticSearch, Solr) has internal process that saves searched counts of each keyword. Using that index would be the way.



4) MapReduce is the best in this case. Distribute process by MapReduce and aggregating the result would be the way.



-End-



I am relatively new to dev world. It was a questionnaire from company where I applied and it makes me wonder which is the best. The application process is already finished so I am not taking advantage of it but just wonder what would be the best way and what field I should study to figure out answer of this kinds of questions easily. Hopefully it is also a positive challenge for you.



Thanks.










share|improve this question


























    0















    Question.



    Let's say you work for search engine company and you would like to see TOP 50 of most-searched keywords of yesterday. If access logs are distributed over thousands of server, what would be the best way to achieve your goal?



    1) Redis shows the great performance in this case. Creating a program that checks searched counts by search keyword, let it read all distributed logs, and find the top 50 by using Redis command would be the way.



    2) RDS is the best in this case. Create a program that checks searched counts by search keyword and find top 50 by SQL command.



    3) Search Engine(ElsaticSearch, Solr) has internal process that saves searched counts of each keyword. Using that index would be the way.



    4) MapReduce is the best in this case. Distribute process by MapReduce and aggregating the result would be the way.



    -End-



    I am relatively new to dev world. It was a questionnaire from company where I applied and it makes me wonder which is the best. The application process is already finished so I am not taking advantage of it but just wonder what would be the best way and what field I should study to figure out answer of this kinds of questions easily. Hopefully it is also a positive challenge for you.



    Thanks.










    share|improve this question
























      0












      0








      0








      Question.



      Let's say you work for search engine company and you would like to see TOP 50 of most-searched keywords of yesterday. If access logs are distributed over thousands of server, what would be the best way to achieve your goal?



      1) Redis shows the great performance in this case. Creating a program that checks searched counts by search keyword, let it read all distributed logs, and find the top 50 by using Redis command would be the way.



      2) RDS is the best in this case. Create a program that checks searched counts by search keyword and find top 50 by SQL command.



      3) Search Engine(ElsaticSearch, Solr) has internal process that saves searched counts of each keyword. Using that index would be the way.



      4) MapReduce is the best in this case. Distribute process by MapReduce and aggregating the result would be the way.



      -End-



      I am relatively new to dev world. It was a questionnaire from company where I applied and it makes me wonder which is the best. The application process is already finished so I am not taking advantage of it but just wonder what would be the best way and what field I should study to figure out answer of this kinds of questions easily. Hopefully it is also a positive challenge for you.



      Thanks.










      share|improve this question














      Question.



      Let's say you work for search engine company and you would like to see TOP 50 of most-searched keywords of yesterday. If access logs are distributed over thousands of server, what would be the best way to achieve your goal?



      1) Redis shows the great performance in this case. Creating a program that checks searched counts by search keyword, let it read all distributed logs, and find the top 50 by using Redis command would be the way.



      2) RDS is the best in this case. Create a program that checks searched counts by search keyword and find top 50 by SQL command.



      3) Search Engine(ElsaticSearch, Solr) has internal process that saves searched counts of each keyword. Using that index would be the way.



      4) MapReduce is the best in this case. Distribute process by MapReduce and aggregating the result would be the way.



      -End-



      I am relatively new to dev world. It was a questionnaire from company where I applied and it makes me wonder which is the best. The application process is already finished so I am not taking advantage of it but just wonder what would be the best way and what field I should study to figure out answer of this kinds of questions easily. Hopefully it is also a positive challenge for you.



      Thanks.







      database performance search server






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 7 at 6:05









      Kim HyungJuneKim HyungJune

      6110




      6110






















          0






          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55037069%2fbest-way-to-retrieve-top-50-values-from-the-choices%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55037069%2fbest-way-to-retrieve-top-50-values-from-the-choices%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          1928 у кіно

          Захаров Федір Захарович

          Ель Греко