Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

Performance is slow

small database (1000 Records) that takes 15 seconds to open form.  Form has sub forms based on query and a subform from that form.  Data is in a separate database on a network server.  Looking to improve performance.  need suggestions. Thanks.
0
Startrac98
Asked:
Startrac98
  • 4
1 Solution
 
sdstuberCommented:
can you post some code? or at least some trace information about where performance lag is coming from?

querying 1000 records should be sub second for most operations.


0
 
Startrac98Author Commented:
Sorry, Please move to MS Access 2007 zone.  Thank you
0
 
Dale FyeCommented:
How are you accessing the information in your backend database?

Linked tables
ADO

If linked tables, are use querying the linked table, or using pass-thru queries?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
Startrac98Author Commented:
querying the linked tables
0
 
Startrac98Author Commented:
Resolved issue by re-designing flow
0
 
Startrac98Author Commented:
ok, please close
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now