Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Speed issue with SQL

Status
Not open for further replies.
teach314

teach314

Technical User
Jul 29, 2011
183
CA
hello

I am using SQL (in MS Access 2002) to process a very large amount of data in a mathematics research project. Much of the work runs on a Windows 7 OS machine, and I am quite happy with the speed of processing. Last month, I added a second computer that is almost identical to the first machine, but it came with a Windows 8 OS. The SQL is running MUCH slower on the new machine. Here's a few details...

1) Dell XPS-8500 i7-3.4 GHz 12 G memory Windows 7 :Trial run takes 2.00 hours to run (quite fast)

2) Dell XPS-8500 i7-3.4 GHz 16 G memory Windows 8 :Trial run takes 3.22 hours to run (quite slow)

The Trials involved running the identical SQL tasks on both computers.

What am I missing here? Is there some reason why the 2nd machine performs so miserably? Can any of the experts out there suggest why two almost-identical machines should perform so differently?

Many thanks for any help
Teach314


 
Sort by date Sort by votes
A sample of the SQL would be helpful. You don't mention if there are any linked SQL Server tables and/or a split database. If you are executing any stored procedures or pass-through queries, try switching scenarios between ODBC and OLEDB providers in your ADO connection strings.

Beir bua agus beannacht!
 
Upvote 0 Downvote
Hi genomon - It's hard to send actual SQL, because I execute a very long list of DAO procedures that generate then execute SQL statements. There are no shared tables or split databases. Each machine operates as a stand alone. The only difference between the two practically identical computers is that the one running Access 2002 under Windows 8 is MUCH slower that the one running the identical code under Windows 7.

I guess I just wondered if anyone else has experienced this problem and had insights as to how to rectify it.

Teach314
 
Upvote 0 Downvote
Any chance that table indexes or PKs were altered or lost on the Win8 box installation?

Beir bua agus beannacht!
 
Upvote 0 Downvote
The PK's and indexes were not changed intentionally, but I'll check this anyway when I'm home tomorrow. Thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
859
strongm
strongm
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
766
dhookom
dhookom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
909
Swi
Swi
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
870
serino
serino

Part and Inventory Search

Sponsor

Back
Top