Performance issue

S

Souris

I have an app which has Access front end interface and SQL server backend
application.

I found that this application is slow samtimes, but not always.

For example, It is very slow when user scrolls (browses) the data.
It is Ok when I launch the application. The speed is OK.
It happens to slow if I leave it opens for a while and come back to browse
data.

They are same data. The system does not chnage it at all.
Somtimes the speed is OK when I come back to browse data.

Is it possible the server or networ busy to make it slow?
If yes, how can I prove it?
Are there any solution for this type issue?

Your informaiton is great appreciated,
 
R

Rick Brandt

Souris said:
I have an app which has Access front end interface and SQL server
backend application.

I found that this application is slow samtimes, but not always.

For example, It is very slow when user scrolls (browses) the data.
It is Ok when I launch the application. The speed is OK.
It happens to slow if I leave it opens for a while and come back to
browse data.

They are same data. The system does not chnage it at all.
Somtimes the speed is OK when I come back to browse data.

Is it possible the server or networ busy to make it slow?
If yes, how can I prove it?
Are there any solution for this type issue?

Your informaiton is great appreciated,
Click to expand...

In a client server application "browsing data" should be avoided. What you
should do is provide tools that allow your user to pull records one at a
time based on those specific records that he wants to see. Pulling lots of
records so the user can scroll around is not an efficient way to set up your
forms.
 
S

Souris

Thanks for the information.
My user interface has dropdown box to let user select the records they need.
It filteres out 10 records only from the whole database which has tens
thousands records.
My business rules does not let narrow down more filter,
When I say browsing data which mean only about 10 records.
It should not take more than one second to move between records.

Thanks millions,
 
R

Rick Brandt

Souris said:
Thanks for the information.
My user interface has dropdown box to let user select the records
they need. It filteres out 10 records only from the whole database
which has tens thousands records.
My business rules does not let narrow down more filter,
When I say browsing data which mean only about 10 records.
It should not take more than one second to move between records.
Click to expand...

What do you have going on in the form's Current event?

Do you have ComboBoxes or ListBoxes that change what is in their RowSource
based on other data in the record?

Are there any subforms?
 
D

Dirk Goldgar

Souris said:
I have an app which has Access front end interface and SQL server
backend application.

I found that this application is slow samtimes, but not always.

For example, It is very slow when user scrolls (browses) the data.
It is Ok when I launch the application. The speed is OK.
It happens to slow if I leave it opens for a while and come back to
browse data.

They are same data. The system does not chnage it at all.
Somtimes the speed is OK when I come back to browse data.

Is it possible the server or networ busy to make it slow?
If yes, how can I prove it?
Are there any solution for this type issue?

Your informaiton is great appreciated,
Click to expand...

I'm not a networking expert, but some networks are set up to drop a
connection after a certain period of idle time. Maybe that's part of
what's going on. Re-establishing the network connection after it has
been dropped would, naturally, take some time.

From your description to Rick, I don't see why just browsing a few
records should be slow when moving from record to record.
 
S

Souris

If it is network issue.
Are there any way to prove?
I should be able to check does connection was dropped or not.
Am I right?
Thanks millions,
 
S

Souris

Yes, I have subform, but nothing going on in form event.
The combobox only use to let user select records.
Thanks again,
 
D

Dirk Goldgar

Souris said:
If it is network issue.
Are there any way to prove?
I should be able to check does connection was dropped or not.
Am I right?
Click to expand...

Unfortunately, I don't know much about networking. I suggest you talk
to your network administrator.
 
Top