[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Slow index searches (AREV Specific) ====
=== At 18 FEB 1999 12:51:23AM Giles Wycherley wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
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
</QUOTE>
----

=== At 18 FEB 1999 05:29AM Steve Smith wrote:  ===

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

</QUOTE>

----

=== At 22 FEB 1999 03:05AM Giles Wycherley wrote:  ===

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

</QUOTE>

----

=== At 22 FEB 1999 04:14AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Ltd[/url] wrote:  ===

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



amcauley@sprezzatura.com 

[url=http://www.sprezzatura.com" ]Sprezzatura Ltd[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]





</QUOTE>

----

=== At 24 FEB 1999 01:18AM Giles Wycherley wrote:  ===

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

</QUOTE>

----

=== At 24 FEB 1999 10:03PM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote:  ===

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

[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=F08A9E82CCCCD3AC8525671C00202BC7|View this thread on the  forum...]]