-
doubleplusjeff committed revision 54 to the Who Voted? SVN repository, changing 7 files.
2009-05-25 11:41:40 UTC in Who Voted?
-
As described in summary. Produces an infinite error array of elements like this:
The election in column 2 has no record of whether the person voted.
2009-05-25 11:17:03 UTC in Who Voted?
-
Example 1: querying once to get the number of results, then a second time to get the actual results.
Example 2: When searching by name and a full state, compare the following queries:
// Runs in 30 seconds
SELECT COUNT(*) FROM Voters
WHERE ( lname = 'Gates' ) AND (Voters.CountyID between '02959' and '02991')
// Runs in 5 seconds
SELECT COUNT(*) FROM Voters USE INDEX...
2009-05-25 10:56:34 UTC in Who Voted?
-
doubleplusjeff committed revision 53 to the Who Voted? SVN repository, changing 1 files.
2008-11-09 15:29:08 UTC in Who Voted?
-
doubleplusjeff committed revision 52 to the Who Voted? SVN repository, changing 47 files.
2008-11-09 13:02:17 UTC in Who Voted?
-
doubleplusjeff committed revision 51 to the Who Voted? SVN repository, changing 3 files.
2008-10-28 17:01:59 UTC in Who Voted?
-
In searching for voters, not all searches (depending on search criteria given) access the "fullname" column of the Voters DB table.
As of this posting, this is immaterial because there is (currently) no data that uses the fullname field. Excluding it for the time being makes voter search queries faster.
However, this must be fixed in the eventuality that we do receive some datafile that...
2008-10-27 22:59:27 UTC in Who Voted?
-
doubleplusjeff committed revision 50 to the Who Voted? SVN repository, changing 7 files.
2008-10-25 17:37:16 UTC in Who Voted?
-
doubleplusjeff committed revision 49 to the Who Voted? SVN repository, changing 21 files.
2008-10-24 20:49:56 UTC in Who Voted?
-
doubleplusjeff committed revision 48 to the Who Voted? SVN repository, changing 1 files.
2008-10-22 16:29:09 UTC in Who Voted?
