[ensembl-dev] Sort biomart output
birney at ebi.ac.uk
Tue Sep 21 15:47:08 BST 2010
Just to provide another route for non-unix people - if you the results
are small, downloading into excel makes it quite easy to sort by column.
On 21 Sep 2010, at 15:31, Andreas Kahari wrote:
> On Tue, Sep 21, 2010 at 04:14:51PM +0200, Asraniel wrote:
>> i was wondering if there was a way to sort the output of biomart. I
>> behind biomart there is just a sql query, so it should be possible
>> to define
>> the row that should be sorted. But i didn't find a way yet.
>> Thank you
>> Beat Wolf
> To be able to show results on the screen quickly, the SQL query is
> processed in batches of increasing sizes. The first batch is limited
> to 10 results, the next to 20, 40, and so on up to some large number.
> Ordering the result would make BioMart extremely unresponsive, and
> probably provoke the user to ask for results multiple times out of
> frustration, overloading the database server.
> Andreas Kähäri, Ensembl Software Developer
> European Bioinformatics Institute (EMBL-EBI)
> Wellcome Trust Genome Campus, Hinxton
> Cambridge CB10 1SD, United Kingdom
> Dev mailing list
> Dev at ensembl.org
More information about the Dev