[AccessD] Time in milliseconds

John:

Demo went well, although the timer I was using didn't show really startling differences, I think they believed me (and you) that it's a good approach when you have multiple sub-forms on a tab form.  The demo you sent me shows about a 2-to-1 advantage and I assume that the advantage becomes more pronounced as the underlying recordsets get larger.


Thanks gain for all your help - especially the last-minute stuff.

Rocky

  ----- Original Message ----- 
  From: John Colby 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, June 26, 2003 8:31 AM
  Subject: RE: [AccessD] Time in milliseconds


  Rocky,

  How'd the demo go last night at the SD AUG?  I just sent you a fully functioning demo of the JIT with a form to time the difference between JIT and non JIT.  On my system here (1.4ghz amd with 512 mb ram), the times for a form with about 4 subforms drawing data from a small movie database were:

  JIT - 86.7 ms
  non JIT - 170 ms

  These are very small simple forms so if your forms get very complex, the difference will be more startling.

  John W. Colby
  www.colbyconsulting.com 

    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin - Beach Access Software
    Sent: Wednesday, June 25, 2003 7:53 PM
    To: accessd at databaseadvisors.com
    Subject: Re: [AccessD] Time in milliseconds


    John:

    Thanks again for your help.

    Ran into a little problem with the ten times opening approach.  It seems that the just-in-time stuff must be triggering by the opening because there was no difference between the two forms (the one with the source and the one without) and the 'calculating...' thingy was displayed at the bottom of the screen in both cases.  

    I'll work on it tomorrow.

    Thanks again.

    Rocky



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030626/c71bbd12/attachment-0001.html>