What is the difference sort in front end vs oracle order by
I am having .5 million records and loaded them in a front end which is nothing but a .net C# grid
which is having some .5 million records and 100 columns.
If i sort the grid on column say column20 (which is of datatype float in database) it takes only 3 sec to sort the entier data and display.
where as if i order by the same column in database which is taking more than 30 sec.
How do i perform this task in oracle.
My requirement is i need to sort the data and give it to user grid as soon as possiable.