Timestamp VS smallint ORDER BY ...?
Posted: Thu Dec 12, 2002 11:44 am
Hi all,
would anyone out there know which situation would be most efficient in terms of less server processing time/resources?
i need a column in my table just for the purpose of doing an occasional ORDER BY either ASC or DESC.
would a timestamp(14) or (12) be better than say...a smallint with an autoincrement?
or is this a trivial question because they would require essentially the same processor resources and time? is there other "better" options??
thanks!
would anyone out there know which situation would be most efficient in terms of less server processing time/resources?
i need a column in my table just for the purpose of doing an occasional ORDER BY either ASC or DESC.
would a timestamp(14) or (12) be better than say...a smallint with an autoincrement?
or is this a trivial question because they would require essentially the same processor resources and time? is there other "better" options??
thanks!