User 22c88daf92
28-11-2012 02:21:26
hello!
We hava two questions:
The First:
When we use structure search in very large dababase, is there any optimize strategy can be used to reduce the search time and memory use? For example, could we defined the search scope in the database or use page search in JchemBase? Could we use the cache to decrease the subsequent or repeated Jchem search time?
The Second:
When we got the search result, how could we specify the order of the result list? For example, by the match score in the substructure search?
Is there any examples in java about above questions? thanks!
ChemAxon a3d59b832c
28-11-2012 07:33:59
Hi,
It looks that you are asking in the context of JChem Base, so I focus on that here. JChem Cartridge is different in these topics.
When we use structure search in very large
dababase, is there any optimize strategy can be used to reduce the
search time and memory use? For example, could we defined the search
scope in the database or use page search in JchemBase?
Yes, there are pre-searching filtering methods and options for timeout. However, there are no ways to control memory use.
See:
http://www.chemaxon.com/jchem/doc/dev/search/index.html#sss_combine
http://www.chemaxon.com/jchem/doc/dev/search/index.html#sss_param
Could we use
the cache to decrease the subsequent or repeated Jchem search time?
Yes, the JChem structure cache works like that. See:
http://www.chemaxon.com/jchem/doc/dev/dbconcepts/index.html#structurecache
When we got the search result, how could
we specify the order of the result list? For example, by the match score
in the substructure search?
You can handle sorting after the results are obtained (if based on a database column, for example), or using the following methods:
See:
http://www.chemaxon.com/jchem/doc/dev/search/index.html#sss_param
http://www.chemaxon.com/jchem/examples/java/html/search/db/SortedSearchExample.java.html
http://www.chemaxon.com/jchem/doc/dev/java/api/chemaxon/jchem/db/JChemSearch.html#setOrder%28int%29
Best regards,
Szabolcs