[iruoy]

I like to have my `*_id` columns at the front, and `created_at` etc. at the back. And in the middle all the fields by descending importance. Just a personal habit so I can quickly lookup data in a table.

[ggregoire]

I'm totally with you on this, and would love to be able to directly reorder the columns in the tables.

A possible workaround is to have a view for every table (which I often read is a good practice anyway) and order the columns as you want in the views.

[pbz]

Exactly... You gain so much speed by having everything in the right order.

[sophacles]

This seems pretty voodoo to me. Do you have any examples that show it?

[pbz]

I'm not sure how I could show if something is easier/harder to work with. Speed in this context refers to human processing speed, not database speed.