cakephp-geo icon indicating copy to clipboard operation
cakephp-geo copied to clipboard

Explore spatial support.

Open dereuromark opened this issue 6 months ago • 1 comments

The whole idea of spatial lookups/filtering is that it should be able to use an index and avoid full table scans.

[
  'id' => (int) 1,
  'select_type' => 'SIMPLE',
  'table' => 'SpatialAddresses',
  'partitions' => null,
  'type' => 'ALL', // !!!
  'possible_keys' => null,
  'key' => null,
  'key_len' => null,
  'ref' => null,
  'rows' => (int) 4,
  'filtered' => (float) 100,
  'Extra' => 'Using where; Using filesort'
]

dereuromark avatar May 25 '25 10:05 dereuromark

:warning: Please install the 'codecov app svg image' to ensure uploads and comments are reliably processed by Codecov.

Codecov Report

Attention: Patch coverage is 96.96970% with 1 line in your changes missing coverage. Please review.

Project coverage is 57.88%. Comparing base (b1d35e2) to head (d6fc445).

Files with missing lines Patch % Lines
src/Model/Behavior/GeocoderBehavior.php 96.96% 1 Missing :warning:

:exclamation: Your organization needs to install the Codecov GitHub app to enable full functionality.

Additional details and impacted files
@@             Coverage Diff              @@
##             master      #76      +/-   ##
============================================
+ Coverage     56.99%   57.88%   +0.88%     
- Complexity      503      512       +9     
============================================
  Files            15       15              
  Lines          1451     1484      +33     
============================================
+ Hits            827      859      +32     
- Misses          624      625       +1     

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

:rocket: New features to boost your workflow:
  • :snowflake: Test Analytics: Detect flaky tests, report on failures, and find test suite problems.

codecov-commenter avatar May 25 '25 10:05 codecov-commenter