Database query/queries on listviews

[dricrm]

Hi all,

When sugar renders a listview for a user, does it fetch all the records from the database and cache them somehow (for when the user clicks next/previous) or does it do multiple queries, one per page?

How about for search pages?

Thanks for your help,
diogo

[andydreisch]

Hi dricrm, ListViews are populated by chunks of results from the database. If you have a ListView that displays 20 records, the database will provide just 20 records' worth of data, even if the search criteria used could result in thousands of records.

If you access the next page, the next set of 20 records are obtained from the database.

If you re-access the first pages (records 1-20), a fresh database query is issued; we do not cache query results as obviously these can change.

I'm not really clear on what you mean by "search pages" as ListViews implement search pages.

Hope this helps,

Andy

[dricrm]

It does!

Thanks for your time.

diogo

[andydreisch]

Happy to help.

Cya,

Andy