Investigate possibility for batched DB queries in PoolDBESSource

[makortel]

After all EDModules have been migrated to EventSetup consumes (#31061), framework knows exactly which ESProducts are consumed at which stages of the application. This information opens up opportunity to try to query many or all payloads from the conditions DB on one go. Such batching should reduce overheads of the DB queries. We should investigate this after #31061 has been resolved (at least for production workflows).

[makortel]

assign core, db

[cmsbuild]

New categories assigned: core,db

@Dr15Jones,@smuzaffar,@ggovi,@makortel you have been requested to review this Pull request/Issue and eventually sign? Thanks

[cmsbuild]

A new Issue was created by @makortel Matti Kortelainen.

@Dr15Jones, @dpiparo, @silviodonato, @smuzaffar, @makortel, @qliphy can you please review it and eventually sign/assign? Thanks.

cms-bot commands are listed here

[makortel]

All EDModules run in IBs have been migrated, and esConsumes is now enforced at run time (#35588). Therefore this optimization could be thought more seriously now.