Once the data was safely stored in the Java structures, serious work could start:
If this isn’t an aggregation, then it’s a very good imitation. It begs the question: why does the query return all rows instead of performing a simple
Some parts of the Java code may require structures with some level of detail, but most queries have been built on the same pattern, including at many places where one is only interested in the aggregate result.
We have no doubt that Java wizards can perform data operations more efficiently than a widely used C database engine that has been slowly improved over the course of more than a quarter of a century. It would indeed be shameful to write a ten-line SQL statement when you can write a full page of Java code to do the very same thing (it gives a better feeling of control, doesn’t it). But, forgetting about efficiency, one might think that given the price of Oracle licenses, the more you do in the SQL code the better ...
|Copyright © RoughSea Ltd, 2006|