questions about new table in JChem 3.1.1

Dear Support,





I have several question concerning the new version of JChem and the


structural change made.


I saw that a table is added to the DB structure: TABLE_UL


what is the use of that table?


If we have a database without this table can we make search


on it without any problems, if the structure table is static and won't be


updated?


How does this table work?


Can we use static table without trigger (TABLE_TR and sequence TABLE_SQ, TABLE_USQ) if we have the structure table unmodified and which won't be updated, deleted or else?


If we use a SQL creation's script of a DB's structure, and then Import Datas from a previous Export. We have, in final, a static table of structures whose contents won't have any variation. So we do need only index to faster the query.


Are those new table, sequence, trigger needed for only querying? And to make Structure search?





Thank you for those precisions.





Warmest Regards,


Jacques

Hi,





The TABLE_UL table store the modifications that were made to the structure table.


These are used by the structure cache to update the cache after changes without the need for a full reload.


(so far these update logs were stored in the property table, but it is better and more efficient this way)

Quote:

If we have a database without this table can we make search on it without any problems, if the structure table is static and won't be updated?

No, because before every search JChem checks if there were new updates logged in this table.


You must have at least an empty table with the same columns.

Quote:

Can we use static table without trigger (TABLE_TR and sequence TABLE_SQ, TABLE_USQ) if we have the structure table unmodified and which won't be updated, deleted or else? [...] Are those new table, sequence, trigger needed for only querying? And to make Structure search?

These are only needed for insert / update / delete operations.


TABLE_TR and TABLE_SQ are used for auto-incrementing the cd_id value in the structure table


TABLE_USQ is needed for generating new update_id values


If you only search in the table (no insert/update/delete/regeneration operation is performed) you can omit them.








Best regards,





Szilard

thank you very much for those precisions