Search speed

[Martin Wright]

Ruslan

Just to note - the database is always read-only and never changes.
My test are done in Director MX 2004 and the files & DB are on a fast server
with a giga network connection.

I did the following in VS:

Reindex
Compact 
Defragment

I then increased the cache:
ValentinaInit(20*1024*1024, "V4MD-****-****-****", "V4DW-****-****-****")

Same problem.
The 1st search takes around 10-12 seconds. Every consequesnt search take 2
seconds - even if I use a different search term.

It's as if it is caching somewhere.

Any other ideas?

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 16:03
To: valentina at lists.macserve.net
Subject: Re: Search speed

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]


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