memory leak or something awfully wrong

[Meyer]

Hi there

I get "Fatal error: Out of memory (allocated 1451491328) (tried to allocate 221 bytes) in C:\xampp\htdocs\lantic\modules\ReportData\ReportDa ta.php on line 215"

as well as "
08/17/09 12:07:08,362 [1688] FATAL SugarCRM - MySQL error 0: SELECT currencies.* FROM currencies WHERE currencies.id = '' LIMIT 0,1
08/17/09 12:07:08,364 [1688] FATAL SugarCRM - MySQL error 0: SELECT parent.name, parent.assigned_user_id, discount.name discount_name, discount.rate discountrate_perc, shipper.name shipper_name, discount2.name purchase_discount_name, discount2.rate purchase_discountrate_perc, shipper2.name purchase_shipper_name FROM accounts acc LEFT JOIN accounts parent ON parent.id = acc.parent_id AND parent.deleted=0 LEFT JOIN discounts discount ON discount.id=acc.default_discount_id AND discount.deleted=0 LEFT JOIN discounts discount2 ON discount2.id=acc.default_purchase_discount_id AND discount2.deleted=0 LEFT JOIN shipping_providers shipper ON shipper.id=acc.default_shipper_id AND shipper.deleted=0 LEFT JOIN shipping_providers shipper2 ON shipper2.id=acc.default_purchase_shipper_id AND shipper2.deleted=0 WHERE acc.id = '127403.0'
08/17/09 12:07:08,370 [1688] FATAL SugarCRM - MySQL error 0: DELETE from tracker WHERE user_id='1' and item_id='127403.0'
08/17/09 12:07:08,370 [1688] FATAL SugarCRM - MySQL error 0: INSERT into tracker ( user_id, module_name, item_id, item_summary,date_modified, owner_id) values ('1', 'Accounts', '127403.0', ' A Botha - 127403','2009-08-17 09:07:08', '')
08/17/09 12:07:08,372 [1688] FATAL SugarCRM - MySQL error 0: SELECT count(*) from tracker WHERE user_id='1'
08/17/09 12:07:08,374 [1688] FATAL SugarCRM - MySQL error 0: SELECT emails_folders.id, emails_folders.reserved, emails_folders.name FROM emails_folders WHERE emails_folders.user_id='1' AND !emails_folders.deleted ORDER by IF(emails_folders.reserved, emails_folders.reserved, 99999), emails_folders.name
08/17/09 12:07:08,382 [1688] FATAL SugarCRM - MySQL error 0: SELECT folder, COUNT(IF(isread, NULL, 1)) AS newmessages, COUNT(*) AS totalmessages FROM emails WHERE folder IN ('b91a4ab9-4236-0ee3-11c9-484ebee39689','ba47a40e-5e47-2f52-8cfc-484ebe709e48','bb5fb486-14e9-4030-1bcd-484ebe6ecc09','bc74b089-18ca-dc9c-33a8-484ebe734d31','1f470fa2-9b2b-796b-cce8-49b0be459fbc') AND deleted = 0 GROUP BY folder
08/17/09 12:07:08,426 [1688] FATAL SugarCRM - MySQL error 0: SELECT category, name, value FROM config WHERE category='MySettings'
08/17/09 12:07:08,439 [1688] FATAL SugarCRM - MySQL error 0: SELECT placement,name,id,url from iframes WHERE deleted=0 AND status=1 AND (placement='tab' OR placement='all') AND (type='global' OR (type='personal' AND created_by='1')) ORDER BY iframes.name
08/17/09 12:07:08,464 [1688] FATAL SugarCRM - MySQL error 0: SELECT tracker.* from tracker WHERE user_id='1' ORDER BY id DESC LIMIT 0,10
08/17/09 12:07:08,547 [1688] FATAL SugarCRM - MySQL error 0: SELECT COUNT(DISTINCT accounts.id) as c FROM accounts LEFT JOIN service_maincontracts contracts
ON (accounts.id=contracts.account_id AND NOT contracts.deleted) LEFT JOIN users
ON accounts.assigned_user_id=users.id LEFT JOIN invoice ON invoice.billing_account_id=accounts.id LEFT JOIN bills ON bills.supplier_id=accounts.id LEFT JOIN contacts primary_contact ON accounts.primary_contact_id = primary_contact.id LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c where accounts.deleted=0
"
but when i run these quesries on mysql it works 100%.
totaly confused.
regards

Paul

sugar 4.1.5

[Meyer]

Indexing, indexing and indexing.
Run slow queries and create indexes. fixed everytjing.

Cheers