Hi Mohitaba,
Sounds to me that it makes sense to put the important 8 fields at least in a
separate table to speed up any SELECT requests.
You may even consider putting a copy of the small table containing only the 8
fields into the memory as a heap table ( if they are not containing any blobs
On Mon, Jun 09, 2003 at 01:40:47PM -0400, Mojtaba Faridzad wrote:
> Hi,
>
> I need to define for example 100 fields in a table. 8 of them are more
> important and many queries just need these fields. Should I define them
> before the other fields in the table or it doesn't matter? Is accessing the
Hi,
I need to define for example 100 fields in a table. 8 of them are more
important and many queries just need these fields. Should I define them
before the other fields in the table or it doesn't matter? Is accessing the
the beginning fields faster than the other fields?
thanks
--
MySQL Gene
