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?
If so, how do I do the conversion?
Thank you for your time.