Timestamp VS smallint autoincr. for table ORDER..?

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 database 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!

I would use the auto_increment option, but if the timestamp is going to be useful in other queries, use it.

The difference in resource requirements and speed is negligible.

Hope this helps 😉

yes...it helps me to eliminate the options because I am already storing a char data type column with date() for a formated date.

so really this newer column would be strictly used for sorting purposes. just wasn't sure if either would be "faster or more efficient."

thanks!