Search speed

[Martin Wright]

Ruslan

We do have indexes (by Word), these are reindexed in VS.
How can we pre-build them before we search?
How can I check how big my cache is?

Martin
 

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: 08 March 2006 13:30
To: valentina at lists.macserve.net
Subject: Re: Search speed

On 3/8/06 3:03 PM, "Martin Wright" <martin at kinetix.co.uk> wrote:

Hi Martin,

> The first search on our 350 MB database (using LIKE) takes around 12 
> seconds.

> Any consequent searches take around 2 seconds.
> Is there a way of speeding up the first search?

Do you have indexes ?

May be first search build them ?

How big is your cache?


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


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina