: 4582 | 108638 | 12353

DB2 Query Views cause unexplainable slowness with SQL queries 
Use this IdeaSpace to post ideas about Domino Designer.

: 0
: 1
: 1
: Domino Designer
: domino
: Mika Heinonen3556 26 Oct 2007
:
: / Email
When you do the same SQL query from the DB2 command prompt (returning 200000 fields), it takes only 5 seconds, but when you do it from an Domino 8 Query View it takes 30 seconds. If IBM doesn't fix this, it's OK, and brings 3rd party vendors a new possibility to create tools which speed up DB2 queries in Domino 8 by a vast amount :)

Click Promote, if you want IBM to fix it.



1) Bruce Lill6687 (25 Jan 2009)
The command line doesn't take into consideration the readers fields and the user's access. In a query View the user's access is based on the db2 username in the person doc or the default view access that is set. This is what takes the time.










:
:




Welcome to IdeaJam™


You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>






IdeaJam developed by

Elguji Software Logo