Home | | | | | |
: 4409 | 106260 | 11906

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 27 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 Lill6677 (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 >>


5
Mail print as PDF or export as PDF
10
Upgrade the admin client. Still has Notes 7 status bar even.
-5
Toolbar buttons for mail Recall and Encrypt
8
Settings / Option for sending read receipt
6
To: field label in memo is a address dialog hotspot. CC and BCC should also be hotspots.
-1
Native Traveler Client for all platforms
7
Add server and database as optional parameters for @GetProfileField and @SetProfileField
6
New "Copy into new Notebook entry" functionnality
3
Stop Opened/Closed session logging for Traveler Servers
5
Improve Support for XPage in Notes Client







IdeaJam developed by