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
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
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
Andy Dreisch
Vice President, Online Team
Check out our Podcasts!
Sugar University for training
Sugar Wiki for developer and user help
SugarForge for modules, themes, lang packs
SugarExchange for production-ready extensions
Enter/view bugs via the Sugar bug tracker
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
check your config.php in the root dir of sugar
look for this line : 'list_max_entries_per_page' => 20,
i hope it helps..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks