On Fri, Jul 04, 2003 at 09:10:41AM -0700, Jay O'Connor wrote:
> I created a database schema and based on the test data I had to work with,
> I couldn't really determine the max size of a lot of string fields so I
> just left a lot of fields as varchar
>
> A comment from a coworker was that this would cause a performance problem
>
> Based on the docs, they say that there's not performance difference between
> using varchar(n) and text.
The only difference comes from checking the length for the limited
fields, so varchar(n) will be very slightly slower than text.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"There was no reply" (Kernel Traffic)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
