date_format is slow

[chaen]

Taken from the jobDB:

MySQL Dirac@dbod-lbwms.cern.ch:JobDB> select count(*) FROM `Jobs` WHERE `Jobs`.`Status` = 'Done' AND `Jobs`.`Site` = 'LCG.CERN.cern' AND `Jobs`.`LastUpdateTime` > '2025-08-25 15:35:31';
+----------+
| count(*) |
+----------+
| 56038    |
+----------+

1 row in set
Time: 0.649s
MySQL Dirac@dbod-lbwms.cern.ch:JobDB> select count(*) FROM `Jobs` WHERE `Jobs`.`Status` = 'Done' AND `Jobs`.`Site` = 'LCG.CERN.cern' AND date_format(`Jobs`.`LastUpdateTime`, '%Y-%m-%d %H:%i:%S') > '2025-08-25 15:35:31';
+----------+
| count(*) |
+----------+
| 56042    |
+----------+

1 row in set
Time: 12.806s

[aldbr]

What's the purpose?

Know if the job is newer than a given date

• Requires SQL proficiency
• Needs to be tested on a production jobDB

Will be done by someone from LHCb ideally because it's easier