Databases
StackOverflow2013
Postsdbo
POHow to improve my Algorithm to find the Hot-Topics like twitter does
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to improve my Algorithm to find the Hot-Topics like twitter does
    text
    copied!<p>I have created a cron job for my website which runs every 2hours and it counts the words in the feeds, and then displays the 10 highest count words as the hot topics. </p> <p>Some thing what twitter does on there homepage, to show the most popular topics that are being discussed. </p> <p>What my cron job does right now is it counts the words except for the words that i have mentioned, words like: </p> <pre><code>array('of', 'a', 'an', 'also', 'besides', 'equally', 'further', 'furthermore', 'in', 'addition', 'moreover', 'too', 'after', 'before', 'when', 'while', 'as', 'by', 'the', 'that', 'since', 'until', 'soon', 'once', 'so', 'whenever', 'every', 'first', 'last', 'because', 'even', 'though', 'although', 'whereas', 'while', 'if', 'unless', 'only', 'whether', 'or', 'not', 'even', 'also', 'besides', 'equally', 'further', 'furthermore', 'addition', 'moreover', 'next', 'too', 'likewise', 'moreover', 'however', 'contrary', 'other', 'hand', 'contrast', 'nevertheless', 'brief', 'summary', 'short', 'for', 'example', 'for instance', 'fact', 'finally', 'in brief', 'in conclusion', 'in other words', 'in short', 'in summary', 'therefore', 'accordingly', 'as a result', 'consequently', 'for this reason', 'afterward', 'in the meantime', 'later', 'meanwhile', 'second', 'earlier', 'finally', 'soon', 'still', 'then', 'third'); //words that are negligible </code></pre> <p>But this does not completely solves the issue of eliminating all the non-required words. And give only the words that are useful. </p> <p>Can someone please guide me on this, and tell me how can i improve my algorithm.</p> <p>Regards Zeeshan</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload