kinglozzer

@dorsetdigital I eventually ended up with

  1. $select = SQLSelect::create()
  2. ->setSelect("Year.Year")
  3. ->setFrom('Year')
  4. ->addInnerJoin('Vehicle', "Year.Year BETWEEN Vehicle.YearFrom AND Vehicle.YearTo")
  5. ->addWhere(["Vehicle.Make = ?" => $filters['Make']])
  6. ->addGroupBy("Year.Year")
  7. ->addOrderBy("Year.Year ASC");

Which, without MySQL query cache enabled, is taking ~70ms for the largest manufacturer (~20,000 rows)

null

indeed. You can point it out to clients and explain the very good reasons for leaving it off, but nobody listens to us 😄

dorsetdigital

Given what I've seen get through ReCaptcha on the highest settings, I think I'd still opt for 'off' 😄

null

The concern is mitigated a lot if you have a spamprotection field on the form

null

EmailRecipient::allow_unbound_recipient_fields

👍 (1)
Josh M

@dorsetdigital As a "we have received your submission" confirmation-type email