IBM®
Skip to main content
    Country/region select      Terms of use
 
 
   
     Home      Products      Services & solutions      Support & downloads      My account     

developerWorks  >  Lotus  >  Forums & community  >  Best Practice Makes Perfect

Best Practice Makes Perfect

A collaboration with Domino developers about how to do it and how to get it right in Domino

I suspect this can be simplified. Thought people might find it amusing.

Andre Guirard | 10 November 2011 08:09:35 AM ET | | Comments (3)


 Comments

1) All I can say is .. WOW
J. Rees | 11/10/2011 9:19:45 AM

But size alone is not a measure of a bad query. I once fixed a huge performance problem by changing a relatively small query to a larger one with a couple of UNION statements. Mine still easily fit on a single page, even if double space though.

But. WOW

2) But it’s SQL, what do you expect?
Doug Finner | 11/10/2011 7:40:58 PM

I've seen a very rational SQL query that was about that long. It was actually a series of separate queries joined together. The query took about 4 hour to run against a 1/2 million row data set and generated a massive csv output file. Man I hated that thing...

 Add a Comment
Subject:
   
Name:
Comment:  (No HTML - Links will be converted if prefixed http://)
 
Remember Me?     Cancel

Search this blog 

Disclaimer 

    About IBM Privacy Contact