labview+Access application low performance

[user_1]

Hi all

I am developing an application in Labview and MS Aceess.

In this,there is a module to plot graph and it is a multipolot graph,there may be arount 18 plots.

All plots are taking data from the same table.

The system takes a long time to fetch records.

In fetching monthly data there may be around 3500+ records in a particular month and tere may be more than 100000 records in the table..I have written query to select record in the particular month only.Still the user has to wait a long time to get response.

Is there any solution for this?

Thanks.......

[Robst]

Hello:

The slow performance may be caused by many issues. An slow PC, a non optimized VI. The number of records should not be a big problem. How long does it take to respond?

Have you tried to index the table?

Could you post your VI to see what can we improve?

Robst

[user_1]

Hi,

Thank you for the reply sir.

The time it takes to respond actually differs in different situations.from1 minute upto 4mts(depending on the number of plots and records)

In the graph there are three scales different plots referring different ones,depending on the value range of the plot.

I havent tried to index the table.How to index the table?If i index the table will it affect other modules?

I am still working on the same application.once i complete i will post the vi

thanks...