Ervin Brindza
viner at eunet.yu
Wed Jul 23 00:06:41 CDT 2003
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 the local machine before invoking a complex set of queries. The downside is a mess of local tables if you overuse the technique.
Stephen,
many thanks for your message!
Best regards,
Ervin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030723/922fd993/attachment-0001.html>