[AccessD] PTW record

Arthur Fuller fuller.artful at gmail.com
Thu Mar 14 19:04:46 CDT 2013


I'm a big fan of PTQs, too. In the absence of ADPs, which work only with MS
SQL, PTQs are a godsend


On Thu, Mar 14, 2013 at 5:36 PM, John W Colby <jwcolby at gmail.com> wrote:

> I am going for the record here.  I have a Pass Through Query which
> currently has 1006 lines of code including comments.  I am commenting
> heavily as you might imagine.
>
> And no, I do not understand a great deal of it.  Sigh.
>
> But at this point it is returning 544 records in just a few seconds.  The
> previous query which this is meant to replace returned the same records in
> somewhere north of 10 minutes.  How far north I will post when I get around
> to comparing my results to the old results.
>
> --
> John W. Colby
>
> Reality is what refuses to go away
> when you do not believe in it
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>



-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr


More information about the AccessD mailing list