W1CDN/aprs_tool
0
0
Fork 0
Code Issues 45 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

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

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

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

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

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
Branches Tags
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 Label
bug
duplicate
enhancement
help wanted
invalid
question
wontfix
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: W1CDN/aprs_tool#69
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?