<!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 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2></FONT><BR> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<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>Stephen,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003>many thanks for your
message!</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003>Best regards,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face="Comic Sans MS"><FONT color=#0000ff><FONT size=2><SPAN
class=049075218-22072003>
Ervin</SPAN></FONT></FONT></FONT></DIV></BLOCKQUOTE></BODY></HTML>