Indexing MySQL Tables

3 posts by 2 authors in: Forums > CMS Builder
Last Post: May 6   (RSS)

By gversion - March 31

Hello,

I have been told that my database tables are not well structured. Columns being joined are of type medium text, which means they are not indexed and are going to perform really bad if the data increases.

Can anyone please advise whether changing the type of the columns will cause any issues with CMSB?

Thank you,

Greg

By gversion - May 6

Hi Daniel,

That's useful to know, thank you for explaining. I have checked the num values and they seem to be int(10) unsigned so I think that looks OK.

However, I will review this in more detail and carry out some tests on a dev environment.

Thanks again,

Greg