Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement Party map caching #438

Open
M4LuZ opened this issue Mar 11, 2019 · 0 comments
Open

Implement Party map caching #438

M4LuZ opened this issue Mar 11, 2019 · 0 comments
Labels
enhancement good first issue If you are just getting started with LanSuite, this issue should be a good place to begin.

Comments

@M4LuZ
Copy link
Collaborator

M4LuZ commented Mar 11, 2019

Expected Behavior

Map is only regenerated if attendee list changes. Optionally also when user edits his postcode.

Current Behavior

Every map access recalcutes map positions.
Implementation is client-wise instead of on the server.
This makes queries (and in case of google cost) increment lineary

Possible Solution

  • Query geolocation service on server (e.g. https://developers.google.com/maps/documentation/javascript/mysql-to-maps )
  • Store results with mapping to postcode in cache / DB
  • Draw from stored results
  • Trigger update when user is set to paid / registered / unpaid / unregistered. So whenever also the party attendee statistics are updated.
  • Additionally the map would also need a redraw if user changes his postcode

Context

This causes the usermap both to be slow and may even cause costs. Thus should be optimized

Your Environment

  • Version used: Git/Master/HEAD
  • Operating System and version: Any
  • Enabled features: Usermap
@M4LuZ M4LuZ added good first issue If you are just getting started with LanSuite, this issue should be a good place to begin. php labels Jan 8, 2023
@andygrunwald andygrunwald removed the php label Mar 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement good first issue If you are just getting started with LanSuite, this issue should be a good place to begin.
Projects
None yet
Development

No branches or pull requests

2 participants