PIVOTAL CRM FORUM PIVOTAL CRM FORUM
Free Pivotal CRM advice from experts
Welcome, Guest. Please login or register.
Did you miss your activation email?
September 08, 2010, 07:30:30 AM

Login with username, password and session length
Search:     Advanced search
A reputed Pivotal CRM consultant starts a Pivotal CRM blog www.pivotalcrm.info
2147 Posts in 649 Topics by 1195 Members
Latest Member: Nelfweels
Home Help Login Register
+  Pivotal CRM Forum
|-+  General Category
| |-+  Performance
| | |-+  Is there an issue with more than 250 columns in a table?		 « previous next »
Pages: [1] Go Down Print
Author Topic: Is there an issue with more than 250 columns in a table?  (Read 765 times)
James.Perry
Guest


Email
Is there an issue with more than 250 columns in a table?
« on: December 06, 2006, 09:30:36 AM »
We have two tables that have more than 250 columns each and Audit System keeps complaining about them.  We have noticed no problems with these tables, but I'm wondering if I should be concerned about it.

What have been your experiences?
« Last Edit: December 06, 2006, 09:32:58 AM by James.Perry » Logged
kwiecin
Global Moderator
Sr. Member
*****

Karma: +0/-0
Offline Offline

Gender: Male
Posts: 84



WWW
Re: Is there an issue with more than 250 columns in a table?
« Reply #1 on: December 07, 2006, 01:43:55 AM »
Whitch databese platform do you use?

In MS SQL Server 2000 max column number per table is 1,024.
But you have to remember also about the row lenght limit which is 8000 bytes per row.

I do not know the Oracle limitations.

Best regards,
MK
Logged
Marcin Kwiecinski
CRM || ITIL Consultant
Microsoft Certified Professional
-------------------------------------------------------------------------
Pivotal CRM Blog - Your everyday Pivotal Web Toolkit
www.pivotalcrm.info
Rus
Administrator
Hero Member
*****

Karma: +0/-1
Offline Offline

Posts: 121
Re: Is there an issue with more than 250 columns in a table?
« Reply #2 on: December 07, 2006, 04:35:30 AM »
The only problem I can think of is that when you use form components in agents to populate / copy too many fields you may come accross a problem where all instructions after 20th or so are ignored by Pivotal.
Logged
One Stop Shop Pivotal CRM Support and Development Service

http://www.pivotalcrmsupport.com
DanClarke
Newbie
*

Karma: +0/-0
Offline Offline

Posts: 4
Re: Is there an issue with more than 250 columns in a table?
« Reply #3 on: September 14, 2007, 03:21:05 AM »
We have three tables with more than 250 columns. The only issue we've encountered is that we use SQLServer replication to suck data to a reporting server, and in SWL Server 2000 the replication can't handle tables with more than 255 columns.

Within Pivotal it hasn't caused us any problems.

Regards,


Dan.
Logged
crmpimp
Full Member
***

Karma: +3/-0
Offline Offline

Posts: 32
Re: Is there an issue with more than 250 columns in a table?
« Reply #4 on: October 15, 2009, 06:42:02 AM »
thats an old warning that used to apply to SQL 6.5 (and SQL 7, i think). It doesn't apply to SQL 2000 or greater, and Pivotal never got around to removing the warning....
Logged
Pages: [1] Go Up Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Pivotal CRM Forum | Powered by SMF 1.0 Beta 5 Public.
© 2001-2004, Lewis Media. All Rights Reserved. 		Valid XHTML 1.0! Valid CSS!