W1CDN/aprs_tool
0
0 Fork 0
Code Issues 46 Pull Requests Projects Releases Activity

Limit number of stations on index page #69

New Issue
Closed
opened 2024-09-12 11:47:58 -05:00 by W1CDN · 4 comments
W1CDN commented 2024-09-12 11:47:58 -05:00
Owner
Copy link
Copy source

Maybe just show stations from the last 24 hours and have links to other timeframes. This may speed up the page load. I don't remember if the count statistic is being calculated on the fly or not; if it is, don't do that.

Maybe just show stations from the last 24 hours and have links to other timeframes. This may speed up the page load. I don't remember if the count statistic is being calculated on the fly or not; if it is, don't do that.
W1CDN added the bug label 2024-09-12 11:47:58 -05:00
W1CDN commented 2024-09-23 10:33:42 -05:00
Author
Owner
Copy link
Copy source

Well, it's not doing it with ?n=20, so need to check on what query parameters I built in.

Well, it's not doing it with `?n=20`, so need to check on what query parameters I built in.
W1CDN commented 2024-11-20 10:55:58 -06:00
Author
Owner
Copy link
Copy source

Limited to 10 by default now: c8f8f28a4a

Still taking like 7 seconds to load the page though. I wonder if a cache table could be made (looks like I mentioned this earlier).

Limited to 10 by default now: c8f8f28a4ac86dde5bd9d6c25dbc4760b17f6b08 Still taking like 7 seconds to load the page though. I wonder if a cache table could be made (looks like I mentioned this earlier).
W1CDN commented 2024-11-20 11:21:26 -06:00
Author
Owner
Copy link
Copy source

Individually, /stations is much faster than /packets, even limited to default 10. Is that because the table is much larger or the query more complex?

Individually, /stations is much faster than /packets, even limited to default 10. Is that because the table is much larger or the query more complex?
W1CDN commented 2024-11-20 19:30:39 -06:00
Author
Owner
Copy link
Copy source

select_frames() now orders by id (index) rather than created and it is much faster now. a5978c2289

`select_frames()` now orders by `id` (index) rather than `created` and it is much faster now. a5978c2289
W1CDN closed this issue 2024-11-20 19:30:51 -06:00
Sign in to join this conversation.
No Branch/Tag Specified
Labels
Clear labels
bug
Something is not working
 duplicate
This issue or pull request already exists
 enhancement
New feature
 help wanted
Need some help
 invalid
Something is wrong
 question
More information is needed
 wontfix
This won't be fixed
No labels bug
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
W1CDN (Matt )
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: W1CDN/aprs_tool#69