CiviCRM Community Forums (archive)

Has anyone ever had any "running out of memory"  trouble with custom reports?  I've got 3 custom reports that all query every contact and left join them to a lot of other data (address, phone numbers, etc).  With just over 30,000 contacts, I get an out of memory error when trying to preview any of the 3 reports from the create report from templates page so that I can then create a report based on my custom templates.  I bumped the memory_limit in the php.ini file up and 2 of the 3 started working -- that is, it was able to load the page after clicking the 'preview' button on the 'create report from template' page .  However, I've raised memory_limit as high as 10240M and still the last of my 3 reports will not work.  I always get the out of memory error and the page containing the 'create report' section will not load.  If I alter the query to only yield one or two results then it works fine.  Does anyone have any ideas?

thanks,
axlroach