Re: Database link performance

    John P. Higgins wrote in message <363530F3.135E90DD_at_deere.com>...     Don't worry about the faster database. The slowest database around is like the spped of light compared to the network traffic.

    || Does this apply to a win95 single disk 133MHz box over a T1 line to a 8-way NUMA-Q Sequent box? Generalizations are generally dangerous. ;-> In this case, I'd be creating views on the Sequent to force the bulk of work there....just a thought, no flames please....

    Plan the join to minimize the network traffic.      Gee, I thought that's what I said.

    Ross Mohan wrote:

        Mostly you want to avoid doing JOINs over the link. You can force a join to

        occur on one db or the other by creating appropriate views there. That way, JOIN

        rows are not shuttled across the network, just the result set. Received on Thu Oct 29 1998 - 22:38:13 CST