LHow to Limit the query in Listview

[Romanzote]

Hi, does anybody knows how to limit the query in Listview.
I have a huge performance problen, while the system is retriving all the records from the database.

Roman

[andydreisch]

Hi Romanzote,

Jacob conducted a session on performance and this topic came up. This Wiki article provides a link to Jacob's prezo ("Performance and Clustering"). The PPT should be sufficient to address this.

Andy

[Romanzote]

Hi A+ndy, I have done al the recommendations, but my installation is still retrieving al records from the db when I go to listview. i am looking for a solution to prevent the query to load all records. just the number I want. I think there is a issue in the listview files. How does "query_limit" works Any Idea.

Roman

[dscriptor]

check your config.php in the root dir of sugar

look for this line : 'list_max_entries_per_page' => 20,

i hope it helps..