Alpha Video Training
Results 1 to 4 of 4

Thread: Form is slow until you click first and last record of the navigation

  1. #1
    Member MikeData's Avatar
    Real Name
    Mike Data
    Join Date
    Nov 2008
    Posts
    923

    Default Form is slow until you click first and last record of the navigation

    I have a form from a set of 4 tables
    master table about 80,000 records first subtable about 200,000 records.
    the other 2 subtables about 3 to 4k records each.
    Upon entering the form the behavior is very slow. If I go to any of the subtables, they barely move.
    If I click first record and click the last record and back. The behavior becomes normal and quick.
    I have a button in the first large subtable to open that line, After clicking first and last, it goes in instanltly.

    Is there a setting for the events ONenter, fetch or other to avoid the need of the first and last record click?
    Is there somewhere a setting, I should check, That is creating this behaviour?

  2. #2
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,395

    Default Re: Form is slow until you click first and last record of the navigation

    Check;
    ..Linking Field lengths - need to be the same length and ideally type unless you are using Expressions to create them.
    ..Avoid linking on multiple fields.
    ..Setting the requsite Indexing.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  3. #3
    Member MikeData's Avatar
    Real Name
    Mike Data
    Join Date
    Nov 2008
    Posts
    923

    Default Re: Form is slow until you click first and last record of the navigation

    Thanks for responding.
    I did check for consistence in field type and size.
    They are the same type and size.
    They are indexed.
    They are single field relation. No multiple fields indexing.
    No code behind this linked filed.
    One thing is they are not the first field in the table, they ocuppy either the 3rd or 4th place.
    The first field in the tables are the IDnos.
    Will this matter?

    "Setting the requsite Indexing" what is this?

    Any other suggestions?

  4. #4
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,395

    Default Re: Form is slow until you click first and last record of the navigation

    When you open a form Mike, you can select the Index to use.
    If you select Record Number, if will be necessary for table 1 to try and link to table two by searching for a match.
    Look at the indexes you have set and see if it is possible to use LQS ( lightning quick searches) by using the same odd across the set.
    The position of the linking field may have something to do with matters. Try moving the linking field to the first position in all tables.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. very slow record navigation
    By fddizon in forum Alpha Five Version 10 - Desktop Applications
    Replies: 9
    Last Post: 02-03-2011, 06:41 PM
  2. How to call modal form or any form on double click on an active control
    By hjawad in forum Alpha Five Version 9 - Desktop Applications
    Replies: 0
    Last Post: 12-27-2008, 04:20 AM
  3. "Next record" form navigation button annoyance
    By brett s in forum Alpha Five Version 7
    Replies: 30
    Last Post: 05-07-2006, 07:23 PM
  4. How to disable record navigation on a form?
    By jmatienza in forum Alpha Five Version 7
    Replies: 4
    Last Post: 04-27-2006, 07:31 AM
  5. Record Navigation
    By julian lewis in forum Alpha Five Version 6
    Replies: 6
    Last Post: 08-09-2004, 08:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •