Test Results III Straight Forward Searches

• Goal: Test data transfer from Oracle to Cartridge and back, and speed of index on SMILES.

• Approach: Time counting the number of hits that some queries would return.

• SQL:

  • select count(*) from TEST_SMILES where DDUSER.CONTAINS(smiles, . . .);
  • select count(*) from TEST_SMILES where DDUSER.MATCHES(smiles, . . .);

Notes: