Re: [SQL] PERSISTANT PREPARE (another point of view)

2008/7/20 Milan Oparnica <[EMAIL PROTECTED]>: > Pavel wrote: > >> >> try to write prototype and show advantages... > > Prototype of what, implementation into Postgre or just efficiency of > PRESISTANT PREPARE idea ? really prototype > >> ...but I see some disadvatage >> too. Mainly you have to m

Re: [SQL] PERSISTANT PREPARE (another point of view)

Earlier, I wrote: Exactly what is gained by the use of persistent prepare over the use of a stored procedure? Er, ENOCOFFEE. Sorry. The benefit is obvious with use of global prepared statements at the wire protocol level rather than via SQL EXECUTE . It's a lot more efficient than EXECUTE o

Re: [SQL] PERSISTANT PREPARE (another point of view)

Milan Oparnica wrote: I found this link from IBM DB2 developers showing why PERSISTENT PREPARE is a good idea and how could it be implemented. [snip] NONE OF POPULAR SQL DBMS (Oracle, MS SQL, MySQL, Postgre, INTERBASE, FIREBIRD) HAVE THIS FEATURE. WHY ? I suspect that people tend to use S

Re: [SQL] PERSISTANT PREPARE (another point of view)

I found this link from IBM DB2 developers showing why PERSISTENT PREPARE is a good idea and how could it be implemented. http://www.hoadb2ug.org/Docs/Favero20606.pdf It seems that main benefit (beside efficiency) is memory. Having number of connections all with dozens of PREPARED statements co

Re: [SQL] Size or efficiency differences "varchar(128) vs. varchar(32)"

Sorry, forgot to replay all. Emi Lu wrote: May I know does varchar(128) and varchar(32) will cause any size or efficiency differences? None at all. Basically, there is no efficiency differences at all, if I know a column is now varchar(32) but could be potentially increased to length(co

Re: [SQL] Size or efficiency differences "varchar(128) vs. varchar(32)"

On Mon, Jul 21, 2008 at 8:06 AM, Emi Lu <[EMAIL PROTECTED]> wrote: > Good morning, > > I'd like to create a varchar length column. > > May I know does varchar(128) and varchar(32) will cause any size or > efficiency differences? If you store the same thing in each, no. If you store 128 char text

Re: [SQL] Size or efficiency differences "varchar(128) vs. varchar(32)"

Emi Lu wrote: > May I know does varchar(128) and varchar(32) will cause any size or > efficiency differences? None at all. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-sq

[SQL] Size or efficiency differences "varchar(128) vs. varchar(32)"

Good morning, I'd like to create a varchar length column. May I know does varchar(128) and varchar(32) will cause any size or efficiency differences? Thanks a lot! -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma