multiple views of millions of records effect on performance
Hello, We have plan to switch from mysql to couchbase. There is one table named CDR. We save millions of record in it and generate multiple reports. we get info by phone number, by customer, by duration etc. After reading couchbase document, it came to our knowledge that we have to design separate views for each report. Let me know that there would be any effect on performance after the createion of multiple views because we save millions of record on daily basis in CDR table or is there anyother apporach to generate reports. Let me know one more thing that what is the best way to fetch data, do everything from views or GET all the data and then filter in the code.
No answers yet