RE: Re: Reading column values with LotusScript will be faster than either Nathan T. Freeman 18.Aug.05 05:03 AM a Web browser Domino Designer 6.5.3Windows XP
Andre... dude... people like me and Erik design apps that don't get replication conflicts. :-D
Actually, we also design apps that are so data-driven that the performance difference between finding a doc in an index and simply getting a direct handle on it via the UNID (or even NoteID) is a BIG deal.
This discussion reminds me a bit of an article I saw one time from someone at IBMGS. It was this big long article about why they were using Domino J2EE integration to Websphere, which I suppose is a perfect admirable thing to do. But the guy started his article saying that they had some product loading process that took, like, 18 hours to run against < 1 million products. All I could think the whole time I was reading it "man, you must have had a pretty terrible design in your Domino system in the first place."
If you're going to design a Domino app that takes relational approaches, then you have to leverage the parts where Domino scales well. Cross-doc access via UNID scales. @DbLookups end up taking 18 hours to load a million products.