Limiting the number of records in a portal

[picnichouse]

Hello,

I want a portal that shows our most recent 5 orders. The problem is, it takes forever to sort all 20,000 orders by the sort criteria I have on the portal. My portal only shows five rows and doesn't have a scroll bar... any faster way to do this?

Thanks,

Andrew

Sorry if this has been covered before -- I didn't see it anywhere.

[Inky Phil]

Try sorting at the the relationship level rather than in the portal

Phil

[picnichouse]

Tried it... still slow

[Reed]

look up "portal filtering"

Basically you add another set of criteria to the portal relationship that will reduce the number of related records.

For instance, if you have a relationship that says invoices::id=lineitems::fk_invoice_id, the portal will show all the line items for the invoice in the portal.

If you have the following constraint added:

invoices::gMonth=lineitems::lineitem_month

Then the portal will only show lineitems having the month value specified in gMonth.