I've had a problem recently where I have modified a dictionary and

now indexes searches seem to be excruciatingly slow. This has occurred on all client systems that the modified dictionaries have been installed on.

I cannot seem to determine what has slowed it down so much. The number and type of indexes that are installed are variable depending on options that they set.

I wonder whether anyone can give me some tips on how to speed up the

index searches, if possible. I've tried to optimize the symbolics

(would that have any effect?)

Also, does anyone know whether you can make a prompt flash? I thought

that I had seen this before, but maybe it was my imagination.

Any assistance would be appreciated, thanks.

Giles Wycherley

You would be better to Btree index individual non-symbolic fields, rather than index a symbolic.

Symbolics must be resolved at run-time. Worse, if an indexed symbolic on a first file derives values from a second file, and the second file changes, then your symbolic index doesn't get updated until you re-write the record on the first file.

Steve

At the moment I am not indexing any symbolics. Is it possible that anythingelse could be slowing things down, e.g. strong datatyping etc?

Giles

Do you have a mix of _ or . in field names and what version are you at?

amcauley@sprezzatura.com

Sprezzatura Ltd

World Leaders in all things RevSoft

Andrew

Not any longer. We converted them over quite a while ago. Even if they do exist in the dictionary, they aren't in any column that I'm currently indexing.

Giles

Actually, it doesn't really work. If I index on an XLated description, and I change the description, the index will never be updated properly. There was a method to link these files up, and it does work in OpenInsight, but it involved creating relationals and doing some manipulation of the dict records. Not for the faint of heart.

akaplan@sprezzatura.com

Sprezzatura, Inc.

View this thread on the forum...