allfredeneuman
asked on
slow response
I have my data linked to a SQL Server database. I would call this a tiny database as databases go. (Maybe even microscopic my largest table is about 600 rows by 7 columns) Anyway. I think my forms and the queries on the forms are very slow. One time, I went out and got a pizza while waiting for the query to finish. It still was not finished when I got back. But, seriously, what can I do to speed this puppy up.
Thank you
A.E.N
Thank you
A.E.N
post the query.
what is the response time if you execute the sql directly in Sqlserver?
what is the response time if you execute the sql directly in Sqlserver?
not much detail available
Is the workstation adequate? (eg. enough RAM)
Could it be communications to/from the server (i.e network related)
Your database may be tiny, but is the server under stress?
How much data might you be ploughing through at the server end?
Is this poor performance "every time","most of the time" or "specific"? (eg. some queries to server are OK, it just query A and B that allow for pizza time)
Then there may be query efficiency to consider.
Is the workstation adequate? (eg. enough RAM)
Could it be communications to/from the server (i.e network related)
Your database may be tiny, but is the server under stress?
How much data might you be ploughing through at the server end?
Is this poor performance "every time","most of the time" or "specific"? (eg. some queries to server are OK, it just query A and B that allow for pizza time)
Then there may be query efficiency to consider.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you
You may get some help from this active thread now:
https://www.experts-exchange.com/questions/28028446/Me-Dirty-False-performs-badly-with-MS-SQL-Server.html?anchorAnswerId=38883251#a38883251
mx