04-01-2013 07:02 PM
I have about 100 fields that I'm no longer using. Most are yes/no and the rest are fixed field length. The data that was collected is no longer needed (and I have made a backup of the db to maintain an archive of that data)
Once deleted, I will need to create a total of 60 character fields that will be linked to an equal number of contact fields, just as before. I can't use the previous fields because most are going from Yes/no to character.
Will the performance of the db be maintained or improved if I remove and then add the new fields or just delete the fields from the layout and add new fields as desired?
04-02-2013 06:32 AM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
04-02-2013 06:47 AM
Thanks. I was talking about deleting the fields fro the db and then re-creating.