/[projects]/android/TrainInfoService/src/dk/thoerup/traininfoservice/db/StationDAO.java |
Parent Directory | Revision Log
Sticky Revision: |
remove station suffixes from search string before db lookup
also log whether we actually found any with fuzzy str search
remove . on name before fuzzyname search
only calculate the levenshtein distance once
more comment on latitude/longitude
one "AND enabled = true " must be enough
add fuzzy string match in getByName searches
deprecate and move old code around
Refactor dao code so all(nearly) jdbc calls are in one single function
Use a simpler getbyname
Adapt service to new StationEntry location
Move database related classes to it's own package
Add an explanatory comment regarding latitude/longitude
Handle invalid station ID's in request
Add support for dumping all stations as XML
Experimental commit #2, move databeans to common
Experimental: use Simple (simple.sourceforge.net) for XML serialization
Increase "find nearest stations" count from 5 to 8
Narrow search area further
use javaLogging
Log whenever getByLocation do a failover lookup
Narrow it further down
Narrow geo-area further
narrow the geographical limited search area (this is ok now we have a failover)
Rename function
Make sure we always return the same number of stations and increase that number from 4 to 5
remove debug statement
Extract station ID's to timetable xml
Comment about the faster distance calculation
narrow longitude search area
limit the number of distance calculations by only calculating on those stations within 2.5 degrees (lat/long)-range on current server this reduces query time by ~45 ms
Simplify query
Save a part of the distance calculation in the earth_coord column
Enable station aliases
Move function getStationName() function do DAO class
Release resources as soon as possible
Rewrite to use a DAO class for DB access
This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.
ViewVC Help | |
Powered by ViewVC 1.1.20 |