Originally Posted by jmcilhinney

While Matt's advice is sound enough, filtering at the client is not always desirable. What if you have millions of records in total? In that case filtering at the clinet would be slow to load the data initially and slow to filter each time. Retrieving a subset of data from the database each time would be a better choice. Local filtering is certainly easier and potentially quicker for relatively small amounts of data though.