Hi to the forum
It seems that the effects it has differ between different people. Some have reported it having positive effects, others negative. It’s also possible that either of the effects reported, are due to people expecting those results. There is no certainty that it affects recall at all, so advice on frequency is purely personal.
There is a similar topic here Sex and Lucid Dreaming