Skip to main content
This forum is closed to new posts and responses. New discussions are now taking place in the IBM Developer Answers forum.
 
developerWorks
AIX and UNIX
Information Mgmt
Lotus
New to Lotus
Products
How to buy
Downloads
Live demos
Technical library
Training
Support
Forums & community
Events
Rational
Tivoli
WebSphere
Java™ technology
Linux
Open source
SOA and Web services
Web development
XML
My developerWorks
About dW
Submit content
Feedback



developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum

developerWorks

  


RE: Re: Reading column values with LotusScript will be faster than either
Erik C. Brooks 18.Aug.05 09:14 AM Lotus Notes
Domino Designer 6.5.3 Windows XP


So let's say I've got two Docs: A and R. R is my "referenced" doc, whose UNID is stored in A.

Doc A is commonly opened with a form that dynamically pulls data from R for display to the user.

If I get a conflict with A (e.g. "B") then fine... I'm still pulling from R in either case.

If I get a conflict with R (e.g. "S") then A is still pulling from R. Still no problem.


I find it hard to see how using a key value helps in this case. In fact, it could easily make things worse as now all lookups and references from A are pointing to both R and S, making conflict resolution even more difficult!

Domino is horrible at generating unique-across-replica keys. It's practically the #1 most commonly asked question on these forums. But there's one that works really well at an atomic database level - UNID.

I've got a view with ~80,000 documents, each with its own unique readers field. You haven't even dreamt of slow until you try to do an @DbLookup against that. :-) I've got a dual-CPU Opteron box with RAID 1+0 data, dedicated view indexing drive, 4 gigs of RAM, etc. etc. (read: smokin') that uses up an entire CPU for 4-5 seconds trying to handle one lookup to the thing.

I'll digress here for a moment: It wouldn't be that bad if it wasn't for the fact that by the lookup merely *existing* in an action hotspot kills the server when the form is opened over the web... see PMR 50114,442,000 if you'd like -- I'm about to re-open it since nobody seems to understand my point. You can read more about this serious Domimo web scalability problem here:

http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/e818f956c8d5ab2185256fb8005207f3?OpenDocument

In fact, due to this situation and that PMR I ended up rearchitecting the app and changing the hotspot to use @GetDocField and it resulted in a performance improvement of ~90-100 times faster. Most importantly, though, it helped to reduce the impact of whatever the heck was causing the web scalability problem identified in my PMR.




Which is less resource intensive? -... (Robert Pozsgai 11.Aug.05)
. . RE: Which is less resource intensiv... (Nathan T. Freem... 12.Aug.05)
. . . . RE: Which is less resource intensiv... (Mika Heinonen 14.Aug.05)
. . . . . . RE: Which is less resource intensiv... (Andre Guirard 15.Aug.05)
. . . . . . . . RE: Which is less resource intensiv... (Mika Heinonen 15.Aug.05)
. . Reading column values with LotusScr... (Andre Guirard 12.Aug.05)
. . . . So the best method is... (Robert Pozsgai 15.Aug.05)
. . . . RE: Reading column values with Lotu... (Nathan T. Freem... 15.Aug.05)
. . . . . . RE: Reading column values with Lotu... (Mika Heinonen 15.Aug.05)
. . . . . . . . RE: Reading column values with Lotu... (Tony Campbell_C... 15.Aug.05)
. . . . . . . . . . RE: Reading column values with Lotu... (Mika Heinonen 15.Aug.05)
. . . . . . . . . . . . RE: Reading column values with Lotu... (Nathan T. Freem... 16.Aug.05)
. . . . . . . . . . . . . . RE: Reading column values with Lotu... (Nathan T. Freem... 16.Aug.05)
. . . . . . . . . . . . . . . . RE: Reading column values with Lotu... (Mika Heinonen 16.Aug.05)
. . . . . . . . . . . . . . . . . . RE: Reading column values with Lotu... (Nathan T. Freem... 16.Aug.05)
. . . . . . . . . . . . . . . . . . . . RE: Reading column values with Lotu... (Mika Heinonen 16.Aug.05)
. . . . . . . . . . . . . . . . . . . . . . RE: Reading column values with Lotu... (Mika Heinonen 16.Aug.05)
. . . . . . . . . . . . . . . . . . . . . . . . RE: Reading column values with Lotu... (Tony Campbell_C... 16.Aug.05)
. . . . . . . . . . . . . . . . . . . . . . . . . . RE: Reading column values with Lotu... (Mika Heinonen 17.Aug.05)
. . . . . . . . Sorry, you made another mistake (Tom Hug 29.May.06)
. . . . . . RE: Reading column values with Lotu... (Erik C. Brooks 16.Aug.05)
. . . . . . . . RE: Reading column values with Lotu... (Nathan T. Freem... 17.Aug.05)
. . . . . . . . . . Re: Reading column values with Lotu... (Erik C. Brooks 17.Aug.05)
. . . . . . . . . . . . RE: Re: Reading column values with ... (Andre Guirard 17.Aug.05)
. . . . . . . . . . . . . . RE: Re: Reading column values with ... (Nathan T. Freem... 18.Aug.05)
. . . . . . . . . . . . . . RE: Re: Reading column values with ... (Erik C. Brooks 18.Aug.05)
. . . . . . . . . . . . . . . . RE: Re: Reading column values with ... (Nathan T. Freem... 18.Aug.05)
. . . . . . . . . . . . . . . . . . RE: Re: Reading column values with ... (Erik C. Brooks 18.Aug.05)
. . . . . . . . . . . . . . . . . . . . RE: Re: Reading column values with ... (Nathan T. Freem... 19.Aug.05)
. . . . . . . . . . . . . . . . . . . . . . RE: Re: Reading column values with ... (Erik C. Brooks 22.Aug.05)
. . RE: Which is less resource intensiv... (Tom Hug 29.May.06)


Document Options






  Document options
Print this pagePrint this page

Search this forum

Forum views and search


  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Author
Category
Platform
Release
Advanced search

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS
More Lotus RSS feeds

Resources

 Resources
Forum use and etiquette
Native Notes Access
Web site Feedback

Lotus Support

 Lotus Support
IBM Support Portal - Lotus software
Lotus Support documents
Lotus support by product
Lotus support downloads
Lotus support RSS feeds

Wikis

 Wikis
IBM Composite Applications
IBM Mashup Center
IBM Connections
IBM Connections Cloud Developers
IBM Docs
IBM Forms
IBM Mobile Connect
IBM Sametime
IBM SmartCloud for Social Business
IBM Web Experience Factory
Lotus Domino
Lotus Domino Designer
Lotus Expeditor
Lotus Foundations
Lotus iNotes
Lotus Instructor Community Courseware
Lotus Notes
Lotus Notes & Domino Application Development
Lotus Notes Traveler
Lotus Protector
Lotus Quickr
Lotus Symphony
IBM Web Content Manager
WebSphere Portal

Lotus Forums


 Lotus Forums
Notes/Domino 9.0
Notes/Domino 8.5 + Traveler
Notes/Domino XPages development forum
Notes/Domino 8
Notes/Domino 6 and 7
IBM Connections
IBM Mobile Connect
IBM Sametime
IBM SmartCloud Notes
Lotus Enterprise Integration
Lotus Protector
Lotus Quickr
Lotus SmartSuite