<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003>Depends how complex the query is. I managed to
decrease elapsed time on one report from 28 minutes down to 4 minutes by
bringing one table up to</SPAN> <SPAN class=049075218-22072003>the local
machine before invoking a complex set of queries. The downside is a mess
of local tables if you overuse the technique.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003>HTH </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003>Stephen Bond</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003> </SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003> </SPAN></FONT></FONT></FONT><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Ervin Brindza
[mailto:viner@eunet.yu]<BR><B>Sent:</B> Tuesday, 22 July 2003 5:19
p.m.<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Pulling the record source from the server before running
thereport<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>Hi listers,</FONT></DIV>
<DIV><FONT face=Arial size=2>I'm just curious is there any decrease in
network traffic if I save the record source(in temporary table, temporary
database) on the local machine before running the report(or form) ?
</FONT></DIV>
<DIV><FONT face=Arial size=2>TIA,</FONT></DIV>
<DIV><FONT face=Arial size=2>
Ervin</FONT></DIV></BLOCKQUOTE></BODY></HTML>