Re: Embedded SQL inherently faster than others?

Dann Corbit snip:
>>-----Original Message-----
>>From: Kevin [mailto:leinfidel@netscape.net]
>>Sent: Tuesday, May 04, 2004 10:18 AM
>>To: pgsql-general@postgresql.org
>>Subject: [GENERAL] Embedded SQL inherently faster than others?
>>
>>
>>Hello,
>>
>
>>I'm looking for absolute maximum database result speed and if
>>that means writing something in C and embedded SQL, versus
>>Perl using DBI or whatever...that's fine.
>
>
> Benchmark your application.  90% of the time will be in ten percent of...

And if you don't have a method for reusing connections or doing some
connection pooling then for short running sql, much of the time will be
spent on establishing a connection.