"Y Sidhu" <[EMAIL PROTECTED]> writes: > The question is: Is this method of repeatedly establishing and > re-establishing database connections with the same 3 tables efficient?
No. Launching a new backend process is a fairly expensive proposition; if you're striving for performance you don't want to do it for just one or two queries. Look into connection pooling ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly