Hi all,

        I'm in the process of designing a database and I'm a bit of an
optimization freak ...  I'd like to make sure that the actual structure
of the database is optimal.

With that said, my question is about TEXT fields.  In the actual CREATE
TABLE statement, would it make the table "faster" if the TEXT fields
were at the end of the table definition?

In fact, should VARCHAR fields be there as well?

Thanks,

-- 
---------------------------
Jason H. Frisvold
Backbone Engineering Supervisor
Penteledata Engineering
[EMAIL PROTECTED]
RedHat Certified - RHCE # 807302349405893
MySQL Core Certified - ID# 205982910
---------------------------
"Something mysterious is formed, born in the silent void. Waiting alone
and unmoving, it is at once still and yet in constant motion. It is the
source of all programs. I do not know its name, so I will call it the
Tao of Programming."

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to