On Tue, Sep 11, 2012 at 6:35 PM, Sytze de Boer <[email protected]> wrote: > I'm losing my mind over this > > At a client site, they run a report which can take 30 mins to generate, > over the network > When they run it on a local pc, it takes 5 secs
If it's 60 sec vs 5 sec, would it be an improvement to copy the tables to the local drive and then run the query from there? i.e. maybe make this a 10-15 second query, rather than a 60 sec beast.... -- Matt Jarvis Eugene, Oregon USA _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAPT54rbd8R1Yo7i-VhVWoFsKJZq7ZAp91iZ7y1psiT_V=05...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
