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.

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

Phil

Tried it... still slow

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.