Search speed

Wed Mar 8 15:30:10 CST 2006

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]