Apache Service memory growing

[travelfreak]

Hi,

i have sugarcrm running on a virtual Server with 2GB of RAM. In the php.ini file
i have increased the max memory size to 1024MB at the moment (for larger reports
and queries).

User sometimes reporting, that they receive out of memory errors while working
with sugar. Is it normal that apache.exe craps about 1,6GB of Memory and keep
it like a Database server?

What else could i tune? My Database is about 100MB and has about 20000 contacts.
Increase physical memory?

I have installed sugarcrm 5.2.0j, XAMPP 1.7.0 and MS SQL Server 2005.

cheers,
Marcus

[salesagility]

see here for performance tips ... you may find something in here ...

[matthew]

PHP has finite state, meaning that the http request takes place and then PHP processes it and when it's done, the memory is released.

However, what can cause memory to be consumed are the number of connections to HTTP or the various modules in PHP (like the database connections). Also, long running PHP processes can always consume too much memory.

The most important thing to do is to try to understand what the user is doing when they get the memory errors.

A lot of the times, it's going to be something like importing records... If that's the case, then they need to break the file down into smaller chunks.

Reporting can also be a cause of this - there are many open source reporting modules that may not properly tune accordingly for large datasets.

See if they're running a report.