5 Replies Latest reply on Jan 21, 2015 10:25 AM by smith7180

    Best performing way to select records from a table

    smith7180

      Say you're on a transaction record and you want to allow the user to select from all contacts.  Most methods I've seen involve a filtered portal:  the user types some letters in a field (ex. 'ja') and the portal that displayed all contacts now filters to only matching ( ex. jack, jane, Janice, etc...)  I see now that this is a slow method that pulls way more data than I need.

       

      Can someone point me in the direction of discussions/tutorials of more efficient ways to do this?  I don't want to ask anyone to do my work/research for me- just looking for some pointers.  I've been putting off learning sql for to long now and am wondering if perhaps it would offer me a quicker solution to this problem.

       

      Thanks.