Are you using bound data controls? If so that, would explain a lot.
Try executing the queries through unbound recordsets. Also check to
make sure you don't make more calls to the database than is necessary.
Try to limit the rights in the call to what is necessary (For instance,
if you only need to read data, a static read-only recordset can save a
lot of overhead as compared to a dynamic read-write with pessimistic row
locking).
-----Original Message-----
From: Bejoy Mathew (MICO/DAN) [mailto:Bejoy.Mathew@i...]
Sent: Thursday, January 31, 2002 5:22 AM
To: professional vb
Subject: [pro_vb] VB APPLICATION SLOW AT RUNTIME
What are the methods available to make VB application do things faster
at runtime... My application has becom perceivably slow... I am using
Access as backend and lot of queries goes to it at runtime.. The form
manipulates the data and outputs it onto Active reports... Do pour in
your suggestions
regards'
BEJOY