I have a VIEW in mysql that is created from 4 different unrelated tables with a UNION
there is over 25000 records in the view. It was created solely for the purpose of doing a search. There are 4 columns and 2 are the main ones for the searching.
It is rather slow, so I was thinking of converting the view to a table as the view will never change - it is in an old database that serves the searches of archived records only.
Will converting the VIEW to a TABLE speed up the search?
I have 4 cols in the table and 2 have numbers (ID’s) so I put the indexes on them - the other 2 cols are text and long text - can an index go on those also? I think that index is just for numbers but correct me if I am wrong
You can index text and long text in FULLTEXT indexes if you like, but you should only index them if you also search them. If you don’t, then don’t bother