Results 1 to 3 of 3
  1. #1
    Mclaren is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164

    Form Slow but underlying Query Fast

    Hi all,



    So i have a from whose record source is a query (stored in the front end).

    The form that takes significantly longer to open vs running the query separately. There is no substantial code that runs on load that would slow the form down.

    Below is an image of my Forms Data settings:

    Click image for larger version. 

Name:	Form Query.JPG 
Views:	12 
Size:	35.0 KB 
ID:	40671

    Is there anything i should be looking out for.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    when you run the query separately, how long does it take to populate the recordcount which shows at the bottom of the query window - that is the time it takes to load the full query. Otherwise all you are seeing is the first few rows (try scrolling to the last record). Your order by property in your form cannot run until all records are loaded.

    Ordering your query rather than in the form will probably be quicker however a slow query implies either a huge amount of data or poor design, either of the query or the underlying tables. Typically this might be fields used for sorting/criteria not being indexed or the indexing not useable because of an initial * in a LIKE clause.

    Edit - also clarify what is the backend - access? sql server? something else?

  3. #3
    Mclaren is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    Thanks for the advice, I will review my query + table. Oh and ts a MS access Backend.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 03-07-2019, 06:23 PM
  2. Replies: 4
    Last Post: 04-12-2018, 09:09 AM
  3. Slow on 2010 but fast on 2007?
    By Jaffacaique in forum Queries
    Replies: 5
    Last Post: 09-09-2012, 04:16 AM
  4. Replies: 2
    Last Post: 12-16-2010, 02:46 PM
  5. Replies: 0
    Last Post: 02-09-2007, 09:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums