Note that there are some explanatory texts on larger screens.

plurals
  1. USDrew
    primarykey
    data
    text
    plurals
    1. COWhat are the actual transaction errors you are getting in Grails? Are you having real performance problems? Because tomcat-dbcp is based on apache-commons-dbcp, you could see the same problem and you might be better served by switching to something like C3P0 or going with a different application server. [SpringSource tc-Server's DBCP](http://pubs.vmware.com/vfabric52/topic/com.vmware.vfabric.tc-server.2.8/admin/manual-high-concurrency-jdbc.html) "adds additional features to support highly-concurrent environments and multiple core/cpu systems"
      singulars
    2. COWith SQL Server 2005 you'd have a regular table of records with fields for the address. You'd add columns for the latitude & longitude and then have a batch process that would take each address as input and fill in the lat/longs. This is called "geocoding" and can be done using a web service like Google/Yahoo/GeocoderUS. Then your app code would take an input lat/long & perform the search of the table using Haversine. You are right to question the performance since this sweeps the entire table, but the algorithm isn't complex (in Big-O terms; there isn't recursion or anything).
      singulars
    3. COI did attempt a few variations of "factory-method" but that does not work here because ThreadPoolExecutor.CallerRunsPolicy is a regular old Java constructor. This is a static class.
      singulars
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload