Links to 'num' mySQL type in drop down

2 posts by 2 authors in: Forums > CMS Builder
Last Post: September 16, 2016   (RSS)

By Dave - September 16, 2016

Hi Larry, 

Which CMSB version are you using?  The latest release has a pulldown for "MySQL Column Type" with INT as an option.  It's still in the field editor, so you need to click edit on the fieldname, but it's quicker than typing it.  You can also set up basic indexes through the CMS now by clicking "Column Indexing".

Also, I often don't even bother setting column types unless I know there's going to be a lot of records or there is a performance/overhead issue. 

Dave Edis - Senior Developer