3 ms·
Unless you have 3 levels of tables to work through. Yes, you can get all the data from the third level in one query - but then you have to find the keys you wa
by ars 15y ago
Unless you have 3 levels of tables to work through.
Yes, you can get all the data from the third level in one query - but then you have to find the keys you want from it in your client, and without an index. (Alternately you may be building a hash-index on the fly each time you retrieve the data, which isn't optimal either. For example if you store the key in a PHP array.)
Obviously you need to be smart about what you are doing. But simply always getting the data in bulk is not automatically correct.