store sum and number of votes in each quote

This seems to improve the response time.  We don't store a list of
votes for each quote, which mean we don't have to retrieve every vote
when we get the list of quotes.  The only time we need to access the
vote table is when we add a new vote.

1 files changed, 3 insertions, 2 deletions

diff --git a/src/lq/ImportQuotes.java b/src/lq/ImportQuotes.java
index 30ad811..d750b7b 100644
--- a/src/lq/ImportQuotes.java
+++ b/src/lq/ImportQuotes.java
@@ -148,9 +148,10 @@ public class ImportQuotes extends HttpServlet {
         Date timestamp = lq.DateUtil.timestampFormat.parse(getChildWithName("time", voteRow));
         String ip = getChildWithName("ip", voteRow);
 
-        Vote vote = new Vote(rating, ip); 
+        Vote vote = new Vote(quoteId, rating, ip);
         vote.setTimestamp(timestamp);
-        quote.getVotes().add(vote);
+        quote.setSumVotes(quote.getSumVotes() + rating);
+        quote.setNumVotes(quote.getNumVotes() + 1);
         return vote;
     }