Is your application slow?

TIBCO (T): So, we heard you are dealing with some performance problems in your application. You would like to improve your user experience by providing faster access. Is our understanding right?

Customer (C): Yes!

T: What do you think could be the reason for performance problems?

C: We think that database on which our application is running, is not able to accomodate all queries at the same time.?It often gets congested during peak hours of business due to the high load of requests.

T: We can help you here. But before, can you think of any other reaons this might be happening so that we can solve the problem at its core?

C: There could be many reasons like:

?1. Huge number requests in the database during peak hours.

?2. Customers requesting very large datasets (eg: for a year)

?3. We cannot scale up database any more

T: What if you can migrate load to an external location??

C: What do you mean?

T: If there could be a way where your queries do not hit your primary database and leave it for critical tasks like real-time transactions, can it help?

C: Do you mean something like offloading?

T: Yes, data requirements for non critical queries like statement generation, large dataset query can be offloaded to external database.?So that your primary database is now free to fulfill only critical requests and by offloading requests for non real-time requests, you users can get the performance they need.

=================================================================

Take a look into how TIBCO Data Virtualization (TDV) offloading feature can help with reducing congetion on your database.?

Please refer attached snapshots where TDV tries to solve few probelms on data offloading.