import: Consistent fast resume support

0 votes

Vote

Raised 0% of 12 credits
(12 credits = 2 hours or £66.00)

I made some import optimisations as a part of this commit:
https://github.com/ocproducts/composr/commit/fbbbb5d9fabfed72bebbf934aaa7c9a8ea37c389

It allows it to not have to scan through everything to see if already done at the start of a resume.

This should ideally be implemented consistently across…

Suggested by Chris Graham on 3rd September 2019

core: Use emojis in email subject lines

0 votes

Vote

Raised 0% of 18 credits
(18 credits = 3 hours or £99.00)

A good way to attract attention in a crowded inbox, and to summarise an email, is to use an emoji at the start of the subject lines.

Consider an option to the mailer function that specifies what emoji to use, and a global option to decide if the feature is on or not.

Suggested by Chris Graham on 9th October 2019

core: Re-review all indexes

0 votes

Vote

Raised 0% of 18 credits
(18 credits = 3 hours or £99.00)

Review all indexes in the system...

1) Is each necessary? Document why with a code comment. If not, remove (as indexes use disk space and slow writes).
2) Is *sorting* covered on a single index. For example, ideally an index on a category ID will also have a secondary index column on the timestamp, so…

Suggested by Chris Graham on 19th November 2019

core: Option to bypass SMTP relay server

0 votes

Vote

Raised 0% of 96 credits
(96 credits = 16 hours or £528.00)

E-mail is implemented in a complicated way, more complicated and error prone than it needs to be for our situation.

A mail client connects to an SMTP relay server (smarthost), and the message goes into that server's queue - and that server then connects to the recipient's SMTP server (or another relay,…

Suggested by Chris Graham on 7th November 2019

core: Support for descending indexes

0 votes

Vote

Raised 0% of 30 credits
(30 credits = 5 hours or £165.00)

MySQL 8 adds support for descending indexes.

This is particularly relevant for indexes where we sort by descending timestamps (e.g. viewing in a forum).

It improves index performance by about 15%, avoiding the 'Backward index scan'. I'm not sure exactly why a backward index scan is slower, because a…

Suggested by Chris Graham on 18th November 2019

core: Opportunistic scheduler

0 votes

Vote

Raised 0% of 24 credits
(24 credits = 4 hours or £132.00)

Some background Cron hooks are not very time critical, but may have a performance impact. Ideally we would run these hooks only when the server is under low load.

Code in a detector function to find if the server is under 'low load', based on I/O load, CPU usage (uptime command on Linux), and memory usa…

Suggested by Chris Graham on 19th November 2019

catalogues: Narrow-in when browsing per catalogue

0 votes

Vote

Raised 0% of 6 credits
(6 credits = 1 hour or £33.00)

Would be useful to have this option per catalogue rather than a choice which affects them all. May also be useful to do this for galleries and downloads as they have the same option.

Suggested by Adam on 6th February 2020

catalogues: Allow selection of year (and month) only in date field

0 votes

Vote

Raised 0% of 18 credits
(18 credits = 3 hours or £99.00)

There will be instances where the full date for a catalogue entry may not be known. Perhaps only the year is known, or just the month and year. It would be useful if the date field allowed for partial input on the month and year by making the day/month values optional.

Suggested by Adam on 18th February 2020

core_cns: Show ban indicator for Staff on Member directory screen

0 votes

Vote

Raised 0% of 6 credits
(6 credits = 1 hour or £33.00)

It would be useful to know if a member is banned (especially on a site with many members such as compo.sr) as you browse the Members page. As screen space is valuable, perhaps replacing the default avatar with an indicative icon to represent a banned member would save an investigative click when logged in…

Suggested by Adam on 22nd February 2020

core: Uploader: Allow selecting files from multiple directories

0 votes

Vote

Raised 0% of 42 credits
(42 credits = 7 hours or £231.00)

Allow ability to upload files from multiple upload directories in plupload.

Currently, starting a new upload erases what was already uploaded in the form.

Suggested by Patrick Schmalstig on 6th March 2020