Is it needed to sort a database ?

For sort a data table , it seems have to rebuild this table when 
each score enter action .
I do not think it is efficient . 

I do not used SQLite yet , but I know that SQL commend can return data in 
order

SELECT * FROM datatable
ORDER BY  time 


在 2012年6月23日星期六UTC+8下午8时42分16秒,Rahul Vijay写道:
>
> Hello Sir,
>
> my question is, in a database some filed 
> Attempt_id,(Autogenerated),Test_id(foregin key),user_name(varchar), 
> score(double), time(varchar).
> Store a data in a table. I am performed sorting a score, if high score in 
> a top & lowest score is boottom. and again enter a new high score or 
> different score, sorting according by time wise. I means table is sorted by 
> time. if user performed minimum time he reach in a top.
>
> Thank you   
>
>

-- 
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

Reply via email to