Users browsing this thread: 1 Guest(s)
venam
Administrators
(15-02-2018, 04:06 AM)1848 Wrote: Well "this week's" is certainly an improvement. I guess I would still prefer
a paged chronological list of all posts (a timeline if you so will).
Because if you are new here you probably want to browse the last posts
and if you haven't visited for some time New Posts will be vanished after you log out.
I think that would be the same as visiting the forum and pressing the sort by "Last Post", which is the default already.

I've also made the sticky posts visually noticeable by adding a subtle background to them.

(15-02-2018, 04:06 AM)1848 Wrote: 10 seconds is still ridiculous as there are only 15,538 posts and surely not many
queries per second. I think querying a million posts from a SQLite database
running on a Raspberry Pi 2 wouldn't take longer than a second.
It's full text search across all posts. Regardless I've reduced the search limit to 5s, which should be enough for any search.

I'm really thankful for all the new ideas here.


Messages In This Thread
Fixing the forums - by venam - 06-02-2015, 04:59 AM
RE: Fixing the forums - by z3bra - 06-02-2015, 08:58 AM
RE: Fixing the forums - by venam - 06-02-2015, 10:22 AM
RE: Fixing the forums - by z3bra - 06-02-2015, 10:53 AM
RE: Fixing the forums - by z3bra - 06-02-2015, 09:14 PM
RE: Fixing the forums - by venam - 07-02-2015, 02:57 AM
RE: Fixing the forums - by venam - 11-08-2015, 04:40 AM
RE: Fixing the forums - by October - 19-09-2015, 11:31 PM
RE: Fixing the forums - by venam - 20-09-2015, 05:09 AM
RE: Fixing the forums - by kirby - 20-09-2015, 02:37 PM
RE: Fixing the forums - by October - 20-09-2015, 03:49 PM
RE: Fixing the forums - by venam - 21-09-2015, 01:05 AM
RE: Fixing the forums - by dtnt - 21-09-2015, 03:30 AM
RE: Fixing the forums - by venam - 21-09-2015, 09:11 AM
RE: Fixing the forums - by dtnt - 22-09-2015, 03:08 AM
RE: Fixing the forums - by venam - 22-09-2015, 05:00 AM
RE: Fixing the forums - by venam - 29-09-2015, 02:32 AM
RE: Fixing the forums - by venam - 29-09-2015, 04:06 AM
RE: Fixing the forums - by October - 30-09-2015, 01:08 AM
RE: Fixing the forums - by xero - 30-09-2015, 10:33 AM
RE: Fixing the forums - by venam - 30-09-2015, 12:05 PM
RE: Fixing the forums - by xero - 30-09-2015, 12:22 PM
RE: Fixing the forums - by venam - 08-10-2015, 02:36 AM
RE: Fixing the forums - by Mafia - 08-10-2015, 11:22 PM
RE: Fixing the forums - by venam - 06-11-2015, 01:35 AM
RE: Fixing the forums - by October - 06-11-2015, 02:46 AM
RE: Fixing the forums - by venam - 06-11-2015, 03:35 AM
RE: Fixing the forums - by xero - 06-11-2015, 12:57 PM
RE: Fixing the forums - by kirby - 29-04-2016, 10:15 PM
RE: Fixing the forums - by venam - 07-12-2016, 01:13 PM
RE: Fixing the forums - by xero - 07-12-2016, 01:30 PM
RE: Fixing the forums - by acg - 07-12-2016, 10:03 PM
RE: Fixing the forums - by venam - 08-12-2016, 05:09 AM
RE: Fixing the forums - by rocx - 08-12-2016, 01:08 PM
RE: Fixing the forums - by venam - 08-12-2016, 01:10 PM
RE: Fixing the forums - by rocx - 08-12-2016, 01:21 PM
RE: Fixing the forums - by venam - 08-12-2016, 01:27 PM
RE: Fixing the forums - by rocx - 08-12-2016, 01:50 PM
RE: Fixing the forums - by venam - 08-12-2016, 02:03 PM
RE: Fixing the forums - by acg - 08-12-2016, 05:22 PM
RE: Fixing the forums - by venam - 09-12-2016, 01:09 AM
RE: Fixing the forums - by wsaile - 10-12-2016, 08:24 PM
RE: Fixing the forums - by venam - 11-12-2016, 03:48 AM
RE: Fixing the forums - by jkl - 14-12-2016, 02:21 PM
RE: Fixing the forums - by venam - 15-12-2016, 12:54 AM
RE: Fixing the forums - by xero - 20-12-2016, 12:33 PM
RE: Fixing the forums - by jkl - 05-01-2017, 11:46 AM
RE: Fixing the forums - by venam - 05-01-2017, 12:25 PM
RE: Fixing the forums - by jkl - 05-01-2017, 12:28 PM
RE: Fixing the forums - by venam - 05-01-2017, 12:30 PM
RE: Fixing the forums - by jkl - 05-01-2017, 12:32 PM
RE: Fixing the forums - by hades - 06-01-2017, 07:56 PM
RE: Fixing the forums - by venam - 15-02-2018, 06:09 AM
RE: Fixing the forums - by 1848 - 15-02-2018, 06:27 AM
RE: Fixing the forums - by venam - 15-02-2018, 07:08 AM
RE: Fixing the forums - by 1848 - 15-02-2018, 07:14 AM
RE: Fixing the forums - by venam - 15-02-2018, 07:37 AM
RE: Fixing the forums - by 1848 - 15-02-2018, 08:18 AM
RE: Fixing the forums - by resk - 22-02-2018, 02:24 AM
RE: Fixing the forums - by 1848 - 23-02-2018, 04:13 AM
RE: Fixing the forums - by venam - 23-02-2018, 04:27 AM
RE: Fixing the forums - by 1848 - 23-02-2018, 04:49 AM
RE: Fixing the forums - by venam - 23-02-2018, 05:04 AM
RE: Fixing the forums - by venam - 18-05-2020, 05:13 AM
Forum feedback - by 1848 - 13-02-2018, 09:19 AM
RE: Profile page accessiblilty and status privacy - by venam - 15-02-2018, 04:42 AM