Jchem - permanent cache

Dear Chemaxon Team,

In our Compound Registration System, We are going to include the Jchem permanent cache.

we are doing the insert/update/delete/search operations in our Compound Registration System using the Jchem .

So we would like to know how or where to register the cache in the operations of insert/update/delete/search.

we are looking for some sample/example for doing the cache using Jchem .Net API.

For example, how to do in updatehandler for insert; jchemsearcher for search, etc.,

we had gone through the below jchem url, but not yet clear on that.

http://www.chemaxon.com/jchem/doc/dev/java/intro/index.html#cachereg

 

Please reply us regarding this ASAP.

 

Thanks & Regards,

D. Senthil kumar vijai.

 

Dear Senthil,

I'm a bit confused regarding your question: it's not clear to me, why do you want to register the cache in case of inserts, updates, ...

If you want to use a pemanent cache registration then all you have to do is to register your cache with a cache ID when you start your application. The registered cache will automatically get notifications about your inserts/updates/deletes in the database and will be used in searches.

Best regards,
Tamás

Dear Tamás,

Thanks for your reply.

As per the jchem, the cache will be useful in the structure search(when we use jchemsearcher). 

1.) we want to know whether the updatehandler (with duplicate filtering on) will search for the duplicate before inserting a molecule in to the structure table.

2.) will the updatehandler make use of the jchem cache features/functionalities when the permanent cache is registered?

3.) what we expect is that the updatehandler must be using the cache to search and filter the duplicate similar to the structure search(jchem search).

We should not to allow the duplicate structure to be inserted while inserting. Which is the better option for doing this according to jchem? Both of them are for doing the insert functionality,

--> updatehandler with duplicate filtering on (i think this is the preferrable one for this sinerio)

(or)

-->searching the duplicate structure using jchemsearcher api, then if no duplicate found, insert the molecule using updatehandler without duplicate filtering off.

 

Please reply us regarding this ASAP.

 

Thanks & Regards,

D. Senthil kumar vijai.

 

HI,

The duplicate search does not use the structure cache.

It is important that only committed records will be visible. (your connection should be in auto-commit, default)

You can either search seprately or do it in one step in UpdateHandler, it does not really matter, the latter should be a bit more efficient.

Best regards,

Szilard