Message of the day:
Welcome. Latest release: https://www.silverstripe.org/download Community Forum: https://forum.silverstripe.org Features: https://forum.silverstripe.org/c/feature-ideas Archive: https://slackarchive.silverstripe.org
If you have any SilverStripe related questions, please supply the version of Framework you're using.
Did you flush? 🚽 =
Archive temporarily at https://archive.codingplayground.nl (redirect)
@dorsetdigital I eventually ended up with
- $select = SQLSelect::create()
- ->addInnerJoin('Vehicle', "Year.Year BETWEEN Vehicle.YearFrom AND Vehicle.YearTo")
- ->addWhere(["Vehicle.Make = ?" => $filters['Make']])
- ->addOrderBy("Year.Year ASC");
Which, without MySQL query cache enabled, is taking ~70ms for the largest manufacturer (~20,000 rows)
Hide attachment content
// TODO Necessary for TableListField URLs to work properly
What's a TableListField?
If that's legitimately before your time, you're one lucky dude
indeed. You can point it out to clients and explain the very good reasons for leaving it off, but nobody listens to us 😄
Given what I've seen get through ReCaptcha on the highest settings, I think I'd still opt for 'off' 😄
I do have spam protection on it 🙂
ty, will try that one out
The concern is mitigated a lot if you have a spamprotection field on the form
"off" sounds like the best choice for that option!
@dorsetdigital As a "we have received your submission" confirmation-type email