URGENT: query limit of 1000 reached for home module

[Doudounka]

Hello,

One of my users is having this problem on his home page.

Error :query limit of 1000 reached for home module

Looked in the forums and all i saw was some thigs like this : config.php there is memory limit definition that is 'default_limit' => 1000, set it 5000

I have no clue where to find this PHP file or even if I have acces to it.

Is there a way to repair of fix this in the admin section ?

Running Sugar Pro 6.1.2

Thank you

[sts]

You'll find config.php in the main directory of your Sugar installation.

[Doudounka]

Hello,

The installation is not here, and we have no access to it, we are paying a provider to host it and they are the one that installed it. We are the end user, and every call to them is a paying call.

So hopefully there is a way within ADMIN to fix it.

Thank you

[sts]

It is only possible to change it directly in the file.

[Doudounka]

Thank you for the info.

The more it goes the less happy i am with Sugar.......

[sts]

This limitation of query_limit to X is there to help preventing from executing database request with more than X result rows due to the fact that huge result sets could slow down the system or lead to storage problems. Another point is that users normally won't have resulting lists with too much entries. So 1000 seems to be sufficient for many (most?) cases.

Most times it should be possible to reduce the number of results with setting the search options.

[Doudounka]

I understand that and it's good that it should limit the number of records.

But on home page it is impossible to have sugar display more than 1000 result rows......

The home page dashlet have an inlaid maximum of 10 results showned or 50 in the feed.

So we are very far from 1000 when home page display +/- 60 results from the dashlets