Hello there!
I use the BioMart Perl API and just figured out some "problem":
When using the option
uniqueRowsOnly(1)
the API fetches all rows matching the query and afterwards deletes the
ones that are too much (so that only unique ones are returned or printed).
My problem is that I have about 1 mio. datarows and only 18 different
values in the desired Attribute.
This means that the query takes about 10 minutes for the result of 18
values.
Is it possible (or planned, or already implemented somewhere, somehow?)
to implement the uniqueRowsOnly-option using the SELECT DISTINCT option
of SQL?
In this case the query should perform within seconds...
Cheers, Kolja
PS: thanks for the great mart, anyway :)
--
Mankind is a catalyzing enzyme for the transition from a carbon-based to a silicon-based intelligence. -Gerard Bricogne
******************************************************
Dipl. Inform. Kolja Henckel
CeBiTec - Center of Biotechnology
Bielefeld University
33594 Bielefeld
Office: V6-151 Phone: +49-(0)521-106-5177
******************************************************
