>We computed that in a period of 5 years, the table can have as much as 650,000 records and we encountered a slight problem in speed. It takes about 10-15 seconds to get the result using the same query i stated above.
And a word of comfort to what was said before.
In 5 years computers will be much faster.
A moment of silence is our cosmic reset button.