[V4RB2] VText search speed

[Ruslan Zasukhin]

On 4/26/05 3:25 AM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

>> So you say that exists some Barier, after which we have jumped slow down?
>> And size of cache not affect this ???
> 
> And...
> 
>> I'd like test both these dbs
> 
> There is some misunderstanding here. Both of the tables are in one database.
> The master table ("Email") has VarChar, UShort and DateTime fields that are
> indexed and quite fast for 41,000 records.
> 
> The related table ("MessageText") has a VText field that is indexed by words
> and is slower to search. This table has about 57,000 records.
> 
> The uncompressed size of the database is 6.5 GB. Compressed with zip, it is
> 2.78 GB.

Gigabytes? No typo here?  :-)

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

I think you see 10 times difference between VarChar and Text fields in your
database because they contain very different size of data.

Am I right that VarChar - this is subject of letter,
But Vtext its bode.

I think that you have VarChar e.g. Few MB size,
And Text field gives rest Gygabytes.

So of course you see difference.

I do not say that 2 secs this is top speed.
May be it is possible even be faster.
Just I think for now this is perfect time for such database...

On the other hand, I remember that Marcus for 28 millions records did have
searches in 0.2 seconds ...


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