Search speed

[Ruslan Zasukhin]

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

> At the moment we don't reindex with Lingo, only in VS on the final database.

Aha, before put it on CD? Then also I recommend

    Reindex
    Compact 
    Defragment
 
> We have already set the relevent fields to index and index by word.

ok
 
> We use the default:
> ValentinaInit( 4 * 1024 * 1024, "V4MD-****-****-****", "V4DW-****-****-****"
> )

> If adjust the 1st parameter, will it improve the search or do I still need
> to index with Lingo?

Cache improve repeated access to data. In any case set it 10-20MB

But you complain on first search...and you have so small cache...
Hmm. 

Do you mean speed 12 seconds from HDD or CD ?

I see only 2 abilities:

1) Valentina reindex or build new indexed first time.

2) first time is slow because data are loaded from slower HDD and second
time is faster because OS itself cache something...

but I think case 1) is more near to true. Do you use ORDER BY ?
Try next: 

    reindex, then do some major queries. Close db
    open it and do first query. Is it faster now ?

> How do I know how big to make the cache?

No exact rule. Only rule of thumb.


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