Profile Fields: Is there a maximum number

My client wants to have about 525 custom profile fields (all boolean). Is there a maximum number?

I added approximately 175 (give or take) successfully, but now when I drag a "new item" I get a javascript popup. I can still customize the item with a name and type, etc.

The popup has no text in it at all. But when I navigate away and return, the new item is down in the inactive area instead of the active area where I left it. So the problem seems to be with the dragging and dropping functionality. As if the Active area can only hold so many items.

Any suggestions would be appreciated.

Thanks.

- Brian

I am not aware of any limits. But you may want to consider a different way of handling whatever the situation is.

Profile records with 525 fields will slow down all functions throughout dolphin that display any information pulled from the profiles table.

I imagine the site will be much slower.

It maybe that it is MySQL limitation on number of columns per table:

http://dev.mysql.com/doc/refman/5.1/en/column-count-limit.html

Thanks for the idea regarding the MySQL tables size, it was a good direction to look in. I'd say that wasn't it though. I completely deleted a number of fields and then tried adding my own again, but got the same error.

I removed a varchar(255) field which would have freed up 255 bytes. I also removed 6 text fields (9-12 bytes in the actual row each, per http://dev.mysql.com/doc/refman/5.5/en/storage-requirements.html).  So I freed up at least 300 bytes for row definitions.

Boolean profile fields are stored as tinyints, 1 byte each, so my whole mess of 525 fields would only take up about as much as 2 of the varchar(255) fields.

Additionally, my problem is that I can't move the fields from the inactive area to the active area. All of my fields, whether active or inactive, are defined in the Profile table when I poke around in MySQL. Perhaps there is a supporting table that is maxed out, but I'm not finding it.

------

I think the problem might be in the ajax code that helps track fields on the page, whether inactive or active.

If anyone has some thoughts on this, I'd certainly appreciate it.

Thanks.

- Brian