> -----Original Message----- > From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Sent: Thursday, September 30, 2010 10:41 AM > To: Tomcat Users List > Subject: Re: [OT] RE: Tomcat Consultant > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Martin, > > On 9/30/2010 10:50 AM, Martin Gainty wrote: > > i would be interested in what administration overhead with this > > translate_entry table > > Probably about the same as doing a CREATE VIEW. > Actually more like a JOIN. The run-time loaded in and cached the necessary rows from the lookup tables and pulled the data fields needed. Essentially though, it was more like a left-join. To get the effect of a natural join, you had to add a where clause to exclude lines with null lookup return-values. I'm not sure if you could do a full-join, but I never had need to.
__________________________________________________________________________ Confidentiality Notice: This Transmission (including any attachments) may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this transmission in error, please immediately reply to the sender or telephone (512) 343-9100 and delete this transmission from your system.
