: 4582 | 108638 | 12353

DB2 Query Views cause unexplainable slowness with SQL queries 
New idea submissions, commenting and voting are no longer available on this site. Logins have also been disabled.

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 >>


25
Option ExtendedSyntax False (or NotesDocumentExtended False)
2
Use more customization features in ND9 NotesMail
-1
How to Connect Windows Active Directive Group?






IdeaJam developed by

Elguji Software Logo