[ensembl-dev] Sort biomart output

[Ewan Birney]

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:
>> Hi,
>>
>> i was wondering if there was a way to sort the output of biomart. I  
>> suppose
>> 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
>
>
> Hi,
>
> 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  
> would
> probably provoke the user to ask for results multiple times out of
> frustration, overloading the database server.
>
>
> Andreas
>
> -- 
> 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
> http://lists.ensembl.org/mailman/listinfo/dev