> -----Original Message----- > From: Hiroshi Inoue [mailto:[EMAIL PROTECTED] > Sent: 13 March 2003 10:04 > To: Dave Page > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign > > > Dave Page wrote: > > > > It's rumoured that Hiroshi Inoue once said: > > > > > > Does looking up by the catalog keys take no cost ? > > > > Obviously there is cost, but doing a lookup only on demand, > has got to > > be cheaper in the long run than including the entire column > definition > > in the message whether it's wanted or not? > > So if there are 100 fields, should we ask the backend > the column name 100 times ?
No, the column name is there already. This is useful for additional info such as uniqueness, nullability, default value, contraints and so on. Surely you don't want to get the entire relevant bits of the system catalogues with every query unless we specifically request it? Regards, Dave.
smime.p7s
Description: S/MIME cryptographic signature
