Re: [ADMIN] PREPARE/EXECUTE questions... custom functions?

2004-10-18 Thread Postgres User
Joshua D. Drake wrote: Use a connection pooler like pgpool. Thanks for the suggestion, I will look into it and test. There seems to some overhead using that tool. What about custom functions, written in SQL or C? They seem to work until the database is shut down, any thoughts about that for a c

Re: [ADMIN] PREPARE/EXECUTE questions

2004-10-18 Thread Joshua D. Drake
Postgres User wrote: I'm writing a web application inwhich clients will login/out among other stuff. I have be reading on prepared statements and leave you all with an open-ended question. Are prepared statements better and how can I program them to not end at the once the session is over? Use

[ADMIN] PREPARE/EXECUTE questions

2004-10-18 Thread Postgres User
I'm writing a web application inwhich clients will login/out among other stuff. I have be reading on prepared statements and leave you all with an open-ended question. Are prepared statements better and how can I program them to not end at the once the session is over? Thanks, any other sugges