Archive for November, 2006

Time spent in queries

Thursday, November 16th, 2006

I was working on a problem with one of our reports. The customer said it took too long to get results in the report, something like 5 minutes or more. Of course they want to see their results in the blink of an eye, but seeing the kind of calculation and querying that has to [...]

Filed under: Oracle, PL/SQL, SQL, Tools | No Comments »

Cleanup after yourself

Monday, November 6th, 2006

When working with your own arrays in Qnxo, you end up with all kinds of views in the schema that you actually don’t want to be left there. For one because they don’t serve any purpose, except for the CGML code generation, and you don’t want any other code to depend on them, because they [...]

Filed under: Oracle, PL/SQL, Qnxo | No Comments »