mySQL - One large query vs Ajax indivdual queries
- by Mark
Hi guys,
I guess no one will have a definative answer to this but considered predictions would be appriciated.
I am in the process of developing a mySQL database for a web application and my question is:
Is it more efficient to make a single query that returns a single row using AJAX
or
To request 100 - 700 rows when the user will likely only ever use the results of two or three?
Really I am asking what is heavier for the server 2-3 requests with one result or 1 request with 100 - 700 results?
Thanks,
Mark