Hi Ruslan,
I guess it's time for me to ask something I have been wondering about
for quite some time now. What exactly is the difference between VarChar
and String fields? And how do I decide which one to use? I have often
read things like "..in this case VarChar could be faster than String",
or vice versa. But what means "could"? What exectly do I need to know to
use the most effective one? =
I mean, maybe for large text fields, VarChar is faster when reading, but
String is faster when inserting/updtaing, or the like? =
Until today, I'm always guessing which one to use... can you shed some
light on this?
Thanks & happy new year,
Frank+++
Ruslan Zasukhin wrote:
=2E..
> Hi Agustin,
> =
> I have look on your project.
> First comments:
> =
> You often create fields as String[255], String[200].
> =
> This can be very not effective.
> Better to use VarChar[504] in both cases.
--
G=FCnter Schmidt & Co. oHG =
Frank Bitterlich eMail: bitterlich .at. gsco .D.OT de
Schlosserstr. 2-4 WWW: http://www.gsco.de/gsco
D-60322 Frankfurt Tel.: 069 / 156809-29
GERMANY Fax: 069 / 156809-28
©2001 Frank Bitterlich |
