[V4RB2] VText search speed

[Kem Tekinay]

On 4/26/05 3:28 AM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> And you complain for 2 seconds search ?!
> You really are greedy.  :-))

Oh yes, quite greedy.

I created a test database this morning and, yes, you are right that the
amount of data stored in the field makes a difference. My test db has one
VarChar field and one Text field. If I make the VarChar very large (20,000
chars storing 500 to 2000 words per record) and store a little data in the
Text field (no more than 75 words per record), the search on the VarChar is
slower than on the Text field.

My test database will create records of words, both real and made up, and
might be useful to you for testing. Since I wrote it anyway, would you like
a copy?

__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
545 Eighth Avenue, Suite 401                          Pager (917) 491-5546
New York, New York 10018                    http://www.mactechnologies.com

To join the MacTechnologies Consulting mailing list, send an e-mail to:
  mactechnologies_consulting-subscribe at yahoogroups.com