[openstreetmap/openstreetmap-website] Add a limit on the number of points in a GPS trace (PR #4536)

[Tom Hughes]

So after some discussion with @gravitystorm I ran a test import of the largest ever trace which contained about 15 million points and it took a bit over 7 hours to import on my desktop.

Looking at the database a total of 433 traces exist (out of around 10 million) with over one million points and the number per year is frequently in the single digits:

```
 extract | count 
---------+-------
    2008 |     4
    2009 |    10
    2010 |    10
    2011 |     8
    2012 |     7
    2013 |    11
    2014 |    30
    2015 |     4
    2016 |     5
    2017 |     7
    2018 |   230
    2019 |    12
    2020 |    70
    2021 |     8
    2022 |     6
    2023 |    11
(16 rows)
```

As a result the default has now been reduced to one million points though it remains configurable.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/4536#issuecomment-1962865758
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/4536/c1962865758 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20240225/5edbcee7/attachment.htm>