I couldn't find any topic with my question, so I created my own question.
I have a web application with big database which has not lot's of
Insert but has so many search (
This application uses MySQL but as there are some tables which be better to be implemented by NoSQL database, so I want to change the database and convert the data to NoSQL database, but I know that it's cause problem in term of speed, when the users search into the database.
My Question: Is there any way to use SQL database not NoSQL database for almost all the data, but for some columns NoSQL?
Simply saying, about 85% of the database columns are fix but there are some columns who are not fix and they are related to the the record, ex: if the current record is bird, we need a column can_fly but if it's a quadruped, we need the column is_mammal.