[V4RB2] VText search speed

[Ruslan Zasukhin]

On 4/26/05 2:39 PM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

> 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?

You mean you have some project which GENERATE this db ?

Of course this is useful.
Please send to me


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]