Requirements
Contact with Oracle DB in C # to retrieve and save data Does.
Points
With the vast amount of data, performance is slow and memory usage is high, the application displays the whole data in the database, database calls and client side data processing Due to the reaction time is high
proposed solution
Use of pagination (Oracle DB) to display partial data on the screen, the reaction time application will be faster; However, this will make the DB call for each page. We are looking for a solution to get 1 page data from DB and to start the application, after which the remaining data from DB will be a background job to get the local XML DB. Therefore, in the case of the next page, the data will be loaded with XML instead of DB calling DB.
Is this design possible?
Is synchronization between local XML DB and Oracle DB possible?
Personally I'm not really sure to go too far, as a synchronization, and complete Disc Io can be the best "interesting".
Usually, what I found to be good in the past if you actually have a record of "pre-faked" result set for more that you can cache the next 2 and previous 2 pages in memory In this way, user transitions are easy, and after navigating the page, a backend thread will exit and pre-fetch you have it on the next page.
Otherwise, if you do what you are talking about, you are only going to present performance effects and data synchronization and other issues.
Comments
Post a Comment