High memory consumption when getting address book cards #32411
Open
Description
Filing here as an issue to collect findings, I'm not entirely sure if that is something we really can solve properly e.g. by streaming the individual card data rather than keeping them all in memory.
There seems to be at least some additional overhead from #19901 but the major impact is the database result that is loaded.
Some useful queries:
select id, sum(char_length(carddata)) from oc_cards where addressbookid = 7;
select id, char_length(carddata) as size from oc_cards where addressbookid = 7 order by size;
select substring_index(carddata, '\n', 10) from oc_cards where id = 3296;