Details are as below:-
1) Have table:- video_info
2) PRIMARY KEY:- video_id UUID
3) having records around 50000.
4) Table is having around 30-35 columns
5) Using DSE 4.8
Need clarifications and suggestions:-
1) I need to search by few 3-4 columns like Video_title, video_actor etc..
2) If I am implementing Solr indexing on this single table, then we can able to do a query from other columns and much more.. but is it going to effect my READ and WRITE speed.
3) is it will be a good idea or not to implement SOLR directly.
Please suggest on above.