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.