abenitez77
Registered User.
- Local time
- Today, 04:51
- Joined
- Apr 29, 2010
- Messages
- 141
I am having performance issue with a DLookup on a linked view from SQL Server. I am executing a stored procedure in SQL Server that runs and updates the data on a view. I then do a DLookup to get values from the view and it takes about 5 seconds for each DLookup to retrieve the data. When I double click on the view it does take a few seconds to open...so it is the linked view that takes time to open and return records. How can Improve or do this differently to return the values I need quicker?
Code:
sqlstr = "Exec UpdateIncludeTab05 "
Call SQL_PassThrough(strconn, sqlstr)
Me.txt_AmountDue = DLookup("AMOUNT_DUE", "Dyn_" & project_id & "_ClaimRecapSum")
Me.txt_Billed = DLookup("BILLED", "Dyn_" & project_id & "_ClaimRecapSum")
Me.txt_ClaimAmount = DLookup("CLAIM_AMOUNT", "Dyn_" & project_id & "_ClaimRecapSum")
Me.txt_ClipFee = DLookup("Clip_Fee", "Dyn_" & project_id & "_ClaimRecapSum")