Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How fast is inserting in JChem Cartridge?

April 26, 2017cartridge fast inserting jchem

0

Posted

How fast is inserting in JChem Cartridge?

1 Answer

0

Posted

• Inserting 10000 structures into a jc_idxtype-indexed regular structure table: 4 minutes 18 seconds INSERT INTO mytable VALUES(); • Inserting 10000 structures into a JChem structure table: 6 minutes 4 seconds jc_insert(‘‘, ‘mytable’, null, ‘false’, ‘false’); • Inserting 10000 structures into a JChem structure table from a temporary table in one batch without duplicate filtering: 1 minute 20 seconds jc_insert(‘SELECT structure FROM tmptable’, ‘mytable’, null, ‘false’, ‘false’); The configuration was the same as in the cartridge benchmark.