Max No of attributes in table

[Reiden Jhon Pimentel]

can anyone help on how to increase the maximum no. of attributes in a table?

i have a table with a 786 attributes where the max attributes is 128...
is their any way to increase this?


--
Reiden Jhon Pimentel

(632) 9192808555

CONFIDENTIALITY CAUTION : This message is intended only for the use of the
individual(s) or entity to whom it is addressed and contains information
that is privileged and confidential. If you, the reader of this message, are
not the intended recipient, you should not disseminate, distribute or copy
this communication. If you have received this communication in error, please
notify us immediately by return email and delete the original message. Thank
you.

[Frazer Clement-3]

Depending on how the table is updated, queried and indexed, perhaps you
can split the attributes across a number of tables with the same primary
key - a sort of vertical partitioning.  You could then create a view to
give the impression of the original schema.
This view may not be updateable and unique or ordered indexes would have
to be duplicated.  Performance would likely suffer as well.

Frazer

Reiden Jhon Pimentel wrote:
> can anyone help on how to increase the maximum no. of attributes in a table?
>
> i have a table with a 786 attributes where the max attributes is 128...
> is their any way to increase this?
>
>
>  

--
Frazer Clement, Software Engineer, MySQL Cluster
Sun Microsystems - www.mysql.com
Office: Reading, UK

Are you MySQL certified?  www.mysql.com/certification


--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe:    http://lists.mysql.com/cluster?unsub=lists@...