Hello Shawn, You might have thought about this before but what about displaying the highest rank each keyword has been tracked at?
That would be a terribly stressful query (not being able to hit indexes) for the DB server (with the number of users using it it would need to be run multiple times per second) and would end up needing to do a full table scan for every query (across a 10GB/250,000,000 record table). So probably not.
Hi Shawn, Just a thought, can't you just save the rank in a best_rank field of the database and only change it if the current rank is higher (or lower... better!). This way you just have to do a little check with eachquery only when the rank is checked: is the new rank higher than best_rank for this keyword? yes: change the best_rank no: do nothing
Well, i'm not. It would be cool to just have an extra column in the keyword list that shhows you the highest rank you've had so far for that keyword.