Index Text Fast?

[Ruslan Zasukhin]

on 3/2/04 10:57 PM, Michael Ginsberg at lists at mdg.com wrote:

> Hello,
> 
> I am evaluating Valentina for a project where I need to search a lot of
> text.  I will have 1 - 2 million records with a 100 - 200 character
> text field.  

BTW, I think it will be better to use VarChar[504] instead of TEXT.
VarChar is faster.

> I want to search within the text field.  Has anyone used
> Valentina for this type of application?  With a fully loaded computer
> (fast hd, 1gb memory, etc.), what type of response time have people
> seen or should I expect.

Michael, also I wonder.

Is db stable? Or it will add record actively?

May be new feature of Valentina 2.0 -- RAM based db will be good
for such task.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------