the database, and synonyms for the "user account" that I use in my
cfqueries.
Like so:
In Oracle
CREATE DATABASE LINK mylink USING 'yourdatabasehere.domain.com';
create synonym linkedtable for [EMAIL PROTECTED];
In CF
<cfquery...>
Select *
from linkedtable
</cfquery>
And, I havne't noticed any problems with speed at all (Oracle 8.1.7).
----- Original Message -----
From: "Whittingham, P"
>
> I am doing a dblink into secondary Oracle 8i database, it seems very
slow in a cfquery (see below). Is there a faster way ??
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
