On Sat, Nov 27, 2010 at 2:42 PM, Greg Landrum <[email protected]> wrote: > chembl=# select * from mols where m<@'CC(=O)c1ccc2c(c1)C(=O)C(=O)N2C' > and m@>'CC(=O)c1ccc2c(c1)C(=O)C(=O)N2' and > m::text='CC(=O)c1ccc2c(c1)C(=O)C(=O)N2C'::mol::text; > regno | m > --------+-------------------------------- > 246028 | CC(=O)c1ccc2c(c1)C(=O)C(=O)N2C > (1 row) > > Time: 34.449 ms > > chembl=# select * from mols where > m::text='CC(=O)c1ccc2c(c1)C(=O)C(=O)N2C'::mol::text; > > regno | m > --------+-------------------------------- > 246028 | CC(=O)c1ccc2c(c1)C(=O)C(=O)N2C > (1 row) > > Time: 175219.805 ms > > I think the argument against the second query is clear. :-)
Yeah, in the meanwhile I made similar tests and ended up discarding my own idea on the same results; thanks for the full explanation though. > >>> Having a less ugly way of doing equality querying would be useful; >>> that would be a good feature request. >> >> Ok, so where should I report it ? ;-) > > now that's an easy one: > http://sourceforge.net/tracker/?group_id=160139&atid=814653 https://sourceforge.net/tracker/?func=detail&aid=3120707&group_id=160139&atid=814653 -- Gianluca Sforna http://morefedora.blogspot.com http://identi.ca/giallu - http://twitter.com/giallu ------------------------------------------------------------------------------ Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! Tap into the largest installed PC base & get more eyes on your game by optimizing for Intel(R) Graphics Technology. Get started today with the Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. http://p.sf.net/sfu/intelisp-dev2dev _______________________________________________ Rdkit-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
