Dear All,
We are currently working on a telecom project which deals with millions of records per day. This main purpose for the project is to Search the data from the ListBoxes and display the results in TextBoxes.
We are extracting the data from MSSQL Database
My queries are as follows:
1. The data reload is to happen every 10-20 mins
2. What is the best way to optimize QVDs (using incremental QVDs)
* Should we use monthly QVDs (approx. 30 million rows per month). How can we use this in conjunction with incremental load?
3. I have seen that when the data is large it takes time displaying it in ListBoxes and TextBoxes
4. How can we dynamically show the data (Dynamic Update?). Only load and show data when the user selects from any criteria?
5. Any other advice on dealing and displaying large data will be helpful.
Thanks.
