Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-09-2019, 03:26 PM   #16
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,165
Thanks: 15
Thanked 1,576 Times in 1,498 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Code running slow, SQL Server related?

I went from 2.5 hours to 3 minutes simply by removing dLookup()'s. Then got it down to 1.5 minutes by getting rid of VBA entirely and doing the whole thing in an update query.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 09-09-2019, 03:31 PM   #17
Hello1
Newly Registered User
 
Join Date: May 2015
Posts: 161
Thanks: 60
Thanked 3 Times in 3 Posts
Hello1 is on a distinguished road
Re: Code running slow, SQL Server related?

Indeed, update queries are awesome but I'm still a beginner and struggling to create them in some conditions
Currently I'm busy with something else and this is on hold :/
Hello1 is offline   Reply With Quote
Old 09-09-2019, 03:44 PM   #18
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,430
Thanks: 112
Thanked 2,855 Times in 2,601 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Code running slow, SQL Server related?

Just added a screenshot showing average results from my Optimising Queries app. See post #13


__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow running code Acropolis Modules & VBA 4 06-08-2015 12:00 PM
SQL Server Linked Server to Oracle slow --> OpenQuery Solution Rx_ SQL Server 2 05-19-2015 08:25 AM
Qry Running Very Slow Acropolis Queries 4 09-04-2014 02:15 AM
SQL Server Express '05 on top of SQL Server '08 running as mirror? madEG SQL Server 2 11-18-2010 02:59 PM
Slow Running samer General 1 06-24-2005 03:27 AM




All times are GMT -8. The time now is 10:47 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World