Re: Roadmap for FE/BE protocol redesign - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Roadmap for FE/BE protocol redesign
Date
Msg-id 20030313180705.T16715-100000@houston.familyhealth.com.au
Whole thread Raw
In response to Re: Roadmap for FE/BE protocol redesign  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Responses Re: Roadmap for FE/BE protocol redesign  ("Hiroshi Inoue" <inoue@tpf.co.jp>)
List pgsql-hackers
> > 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, you do a single select that returns 100 results...

Then you cache them in your frontend...

Chris




pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Roadmap for FE/BE protocol redesign
Next
From: Hannu Krosing
Date:
Subject: Re: Roadmap for FE/BE protocol redesign