Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brettk
Starting Member
2 Posts |
 Posted - 2003-04-29 : 05:20:46
|
| Hi all,I have a limitation of using Goldmine CRM to manage a large database of contacts. Goldmine table structure is quite rigid in that I can't add a new table (as these can't be used to filter to email etc.) but I can add new fields to the existing tables.Our company is adding a new segment to our business and the easiest way to implement the changes is to add additional fields to one of the tables. Currently this table has about 120 fields, i'm needing to add another 30 or so.Are there any serious issues with a table setup like this? Performance, quering etc? Apart for the fact that is is very inconvenient to browse or look fra a particular field?BrettBrett |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-04-29 : 06:20:08
|
| If you're using SQL2K or SQL7 then the limit is 1024 fields per table. 256 if using 6.5 if i remember correctly !? You will ideally not want to go anywhere near these limits.As you say performance and querying are both issues you will want to look at as well as future changes that may take place, will it continue to grow ? Indexing may be an issue with a table this size. How many records has it got ?If you are wanting to link any of these tables into Access at some stage then access may have limitations with regards to # of fields it can see e.g. Access97 will only let you see the first 256 fields even if you have more in your SQL table.====Paul |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-04-29 : 08:05:50
|
quote:
the easiest way to implement the changes is to add additional fields to one of the tables
...don't know Goldmine, but it has been my experience that things will work out better if you create an adjacent database for the additionals. What happens if you update Goldmine?So use you own utility database to expand proprietory systems. Then reference the purchased one via four part naming. Security is usually easier too.Voted best SQL forum nickname...."Tutorial-D" |
|
|
|
|
|
|
Max number of fields per table