Oracle 8i dblink question

Hi All,   I am doing a dblink into secondary Oracle 8i database, it seems very slow in a cfquery (see below). Is there a faster way ?? TIA, Patrick Whittingham United Space Alliance <http://www.houseoffusion.com/banners/view.cfm?bannerid=40>; <cfquery name='test'   datasource='test_db'    blockfactor='100' > select a,b,c,d,e from  <mailto:sysadm.t1@aaa> sysadm.t1@aaa </cfquery>  

Huh? The second db is slower that this first? Are the boes the same? Are your indexes the same? -Adam Hi All,   I am doing a dblink into secondary Oracle 8i database, it seems very slow in a cfquery (see below). Is there a faster way ?? TIA, Patrick Whittingham United Space Alliance <http://www.houseoffusion.com/banners/view.cfm?bannerid=40>; <cfquery name='test'   datasource='test_db'    blockfactor='100' > select a,b,c,d,e from  <mailto:sysadm.t1@aaa> sysadm.t1@aaa </cfquery>________________________________

I've never tried doing it right in a cfquery. I'm using database links in 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 schema.table@mylink.domain.com; In CF <cfquery...> Select * from linkedtable </cfquery> And, I havne't noticed any problems with speed at all (Oracle 8.1.7). >   I am doing a dblink into secondary Oracle 8i database, it seems very slow in a cfquery (see below). Is there a faster way ?? >

I think dblink allows a 'primary' Oracle database to select/insert/update a 'secondary'  Oracle/IBM/MS db. I setup cfadmin the user/password of the 1st db (schema) and use '@aaa' to reference the actual tables/views in the other database. This allows me to indirectly access the secondary db. This allows me to refer to a db2 database thru Oracle. I hope this helps. Pat <cfquery name='test'   datasource='test_db'    blockfactor='100' > select a,b,c,d,e from   sysadm.t1@aaa </cfquery> Huh? The second db is slower that this first? Are the boes the same? Are your indexes the same? -Adam Hi All,   I am doing a dblink into secondary Oracle 8i database, it seems very slow in a cfquery (see below). Is there a faster way ?? TIA, Patrick Whittingham United Space Alliance <http://www.houseoffusion.com/banners/view.cfm?bannerid=40>; <cfquery name='test'   datasource='test_db'    blockfactor='100' > select a,b,c,d,e from  <mailto:sysadm.t1@aaa> sysadm.t1@aaa </cfquery>________________________________   _____