how to show large amount of data

[abc_18]

My application having data say(3-4 GB ) , which contains old records three to four years data.

If I upload all data in my application thn it will cause performance issue,but end user wants to see all the information.

please suggest how can I achieve this.

[marcus_malinow]

Hi Shikha,

this doesn't sound like a massive amount of data, so I'd look at the following:

1 - optimize your data model. Do you have a star schema? If not, can you remodel your schema to be a star, or at least reduce the number of snowflaked (?) tables

2 - optimize your calculations - can you replace complex set analysis expressions with flags in your data model?

3 - reuse calculations - define them in variables and reuse them in your application rather than entering them in each expression box from scratch. Slight differences in case result in similar expressions being recalculated rather then being retrieved from cache

4 - use the QV Document Analyzer to check if you are loading fields that are not being used in your application

5 - optimize your key fields - use autonumber to convert text keys to integers as these will improve performance of your data model

6 - do you have very granular timestamp fields? Split them out to a date and a time part to reduce storage and improve speed

Finally if having done these your application does not perform as required, consider using document chaining

Marcus