Re: TEXT

In what sense did you see performance problems, are those major problems?
Are there any benchmarks out there?

Thanks a lot

Thomas De Vos

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Eric Jain
Sent: 21 April 2002 22:32
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] TEXT

Are TEXT fields handled like BLOBs or like VARCHARs? The issue is that I
prefer to use TEXT rather than VARCHAR fields in my tables, but couldn't
afford the performance penalty of having Java read each returned TEXT field
separately from the database.

--
Eric Jain

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com