Re: selecting from remote tables

Couldn't you join retek_rag_skus, retek_rag_style, retek_item_sups_add, etc into a single query and select from there. That should significantly reduce the amount of traffic between your database and the remote server, which would speed things up quite a bit. It would also give the optimizer on the remote machine more control over how the statement is processed.

In article <6qbr19$ugq$1_at_nnrp1.dejanews.com>,   alex_n_at_equinoxlt.com wrote:
> Hello
> Here is the code I am trying to optimize:
> for rec in (select * from retek_rag_skus)
> loop
> select style from retek_rag_style where style = rec.style;
> select something from retek_items_sups_add where style = rec.style;
> etc...
> end loop;
>
> all retek_* tables are on the remote server, and the loop is executing
> too slowly (5 iterations per second). Any ideas how to optimize it are
> very wellcome. Btw, exactly the same code will run fine when the remote
> tables are being simulated on a local server. Indexes are applied on
> remote tables.
>
> Thanks,
> Alex
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 11 1998 - 01:46:28 CDT