[TYPO3-calendar] All Events (no records folder)

[Mario Matzulla]

Hi Heinz,

Am 26.07.15 um 21:59 schrieb Heinz Schilling:
> There are about 100 folders in this installation which contains events. Is it not a performance problem to find all folders and in the
> folders get all events and then filter them by categories?

the way we do it is:

1. resolve the folders - there is a TYPO3 function 'pi_getPidList' which does all the work for us. As a result we get a comma separated list
of all folder ids
2. we get all allowed calendar ids
3. we get all allowed category ids
4. we create two long queries for events with categories and without, applying all the filters defined.

So there is no difference in the amount of queries, "just" the query parts. And it shouldn't differ if you have "... and tx_cal_event.pid in
(1,2,3,4) ..." or "... and tx_cal_event.pid in (1) ..."

Does this answer you question?

Regards,
Mario
> 
> Regards, Heinz