I'm writing my first website using php/mysql, and jquery. For the next part, the user will apply filters and sorts to find specific items (like an advanced search, kind of) and there will also be a search box. I want the data to reflect the change as soon as any checkbox filter is changed (currently have a test ajax call with no database query to do this that works well).
Would it be better to re-form the query string and re query the data each time a filter changes, or to make one large query and filter the results depending on the filters?
For the time being, the number of records will be low, but it's possible to grow into the thousands.