Tag Info

Hot answers tagged

7

In order: Is there something which allows you to assert that the application is slow? Is there a non-functional requirement related to performance that the application doesn't fulfill any longer? Does it feel slow (in which case your first concern should be to write down a non-functional requirement which will explicitly tell what are you expecting)? If ...


2

The answer depends on the statistics/optimizer etc. The first query logically asks you to take the two result sets and union them(which implicitly removes duplicates reference). The second says take each result set and remove duplicates, then union them. In the random data case I would expect better performance from the first one. But if your data is ...


1

Your web requests should be reasonably large chunks of data, i.e. a complete customer object rather than an individual field, or a complete invoice rather than each individual line item. It's not hard to see why this is true; the granularity of a web page that displays an invoice should be the same as the granularity of the data being displayed. Otherwise, ...



Only top voted, non community-wiki answers of a minimum length are eligible