I have designed a database that runs fine on my computer. However, when I put it on my client's computer, it runs painfully slow (2 second queries on my laptop, 10+ minutes or lockup on client PC). While running the query, the Disk Usage is at single digit percentage, about 3% CPU, 25% Memory and 0% network. It acts like the computer is throttling MS Access, but I don't know if that is even possible. The PC has 16GB of RAM and a 3.0GHz Quad Core processor. The data is stored in SQL Server on the same PC using a DSN-Less connection.
I'm really at a loss for why it runs so slow on the PC. Does anyone have anything that I should be looking at?
You don't make it clear where you're running your tests Seth. I assume you read and understood clearly that it only makes sense to on the client's PC but I try to avoid assuming where possible as it rarely turns out well.
Was the data you were seeing exclusive to the client's PC? Not something that could have come from your own one in spite of thinking it's linked to the client's one?
All ideas that need to be clarified and tied down before progressing to other thoughts (Assuming we can come up with any).
Doh! Assumptions again!
8  1108  NeoPa 32,556
Expert Mod 16PB
Which of the two PCs is the SQL Server on?
Is it possible it's trying to run on your SQL Server when running on the Client's PC?
Currently I have SQL Server running on both my laptop and the client PC. When I'm developing, then I'm running off of my laptop SQL server. When I test it, I copy the Access FE to the client PC and point to the client PC SQL Server. I can try connecting my laptop to their network and see how that runs.
I will say that if I run a query using SSMS on their PC, it runs just fine.
NeoPa 32,556
Expert Mod 16PB
Try getting on your client's PC and opening one of the SQL linked tables. Does it run slowly? Is it somehow not properly set to the local SQL Server?
I can open the tables within Access just fine. I even created a view in SQL Server and linked that into Access and that opened fine as well. I will be testing the use of my SQL Server tomorrow.
NeoPa 32,556
Expert Mod 16PB
You don't make it clear where you're running your tests Seth. I assume you read and understood clearly that it only makes sense to on the client's PC but I try to avoid assuming where possible as it rarely turns out well.
Was the data you were seeing exclusive to the client's PC? Not something that could have come from your own one in spite of thinking it's linked to the client's one?
All ideas that need to be clarified and tied down before progressing to other thoughts (Assuming we can come up with any).
Doh! Assumptions again!
I had tried opening the tables on the client PC last week, so I already knew that information. The data was exclusive to the network that the client PC was on. The data was the same as I had on my laptop, but there was no connection between the two. This evening I will try connecting my laptop to the network and see how the queries go on the client PC with my laptop being the SQL Server.
Is it possible that the client PC has some sort of Anti-Virus which is running real-time scans against the database files when they're being accessed?
I have now tried connecting to the SQL Server on my laptop with the FE on the client PC and that worked very well. I also tried turning off the Anti-virus, but unfortunately, that didn't change anything. I tried uninstalling and reinstalling SQL Server, but that didn't do anything. I ran out of time to try anything else, but at least I now know that the problem is somewhere between Access and SQL Server on the client PC.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: ajikoe |
last post by:
Hello I need to build table which need searching data which needs more
power then dictionary or list in python, can anyone help me what kind
of database suitable for python light and easy to learn....
|
by: Tom Yee |
last post by:
We just installed SQL Server version 800.194 on a dual processor
server equipped with a gigabyte of RAM, running Windows 2000 Server
operating system. We set up a few databases with (so far) very...
|
by: Thomi Baechler |
last post by:
Hello Everybody
I run the following query against to identical databases. Execution
time on the first DB is 0 seconds, on the other 6 seconds!
SELECT dbo.HRMABZ.EMPKEY ,...
|
by: Toto |
last post by:
I have an access 97 database on a windows 95 platform and windows 95/XP
client that query on the database.
Client computer under 95 have not query problems but computer under XP are
very slow and...
|
by: IkyL234 |
last post by:
I'm using Access2000.
I have just designed a database which seems to be operating very slow on a
network. There are currently only a few records in it.
Should I be compacting it now before it gets...
|
by: Nathaniel Sherman |
last post by:
Alright, folks, here's the deal...
I'm working on migrating a classic ASP website to an ASP.NET codebase.
At the heart of the site is a MySQL database.
To make sure an "in-process" program...
|
by: frizzle |
last post by:
Hi group.
I have a news management system, with a mySQL backend.
I tested it yesterday with 1.000.000+ records, testing my url system.
I pulled out records calling them by the url field. It was...
|
by: grace |
last post by:
i am wondering why my database retrieval becomes too slow...we set up
a new server (ubuntu, breezy badger) machine where we transferred all
our files from the old server.. Our new server uses Asus...
|
by: chrisdavies |
last post by:
Hello!
I've developed an access database for a company split over two sites. The network connection is VERY slow between the two sites and therefore one set of users will be using a VERY slow...
|
by: Marc Baker |
last post by:
Bear with me here folks, I don't know much MS SQL performance.
Wondering if someone can point me in the right direction. I have 1
particular database where queries are slow. To test this theory,...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
