Why does this query take forever?

[Ike]

For some reason, I have a rather large (to me) query, with numerous inner
joins, accessing a remote server, and it is taking about twenty times longer
than most queries to the same database.
The query itself is built programmaticall y within my application, and
example of which is below. I am hoping someone in the group may have some
insight into why this query is so slow, suggesting perhaps a better
structure for it, such that I can go back in and rewrite my code that
creates such queries.

Thanks in advance, Ike

"SELECT DISTINCT
chronology.id,s tatus_id.status ,chronology.com pleted,chronolo gy.completeddat e
,chronology.com pletedtime,acti vities_id.activ ity,chronology. activities_acti v
ity,chronology. activities_atta chment,chronolo gy.activities_a vailable_to_all ,
chronology.upca rds_firstnamela stname,upcard_i d.id,chronology .feedbackrequir e
d,chronology.la ndondate,chrono logy.hasspecifi ctime,chronolog y.datetoperform ,
chronology.time toperform,chron ology.duration, chronology.week ends,chronology .
prefix,statusac tivitieisid.id, associaterespon sible.username, activities_user n
ameid.username, chronology.edit Flag FROM
chronology,stat us,activities,u pcards,statusac tivities,associ ates
INNER JOIN status status_id on chronology.stat us_id=status_id .id
INNER JOIN activities activities_id on
chronology.acti vities_id=activ ities_id.id
INNER JOIN upcards upcard_id on chronology.upca rd_id=upcard_id .id
INNER JOIN statusactivitie s statusactivitie isid on
chronology.stat usactivitieisid =statusactiviti eisid.id
INNER JOIN associates associaterespon sible on
chronology.asso ciateresponsibl e=associateresp onsible.id
INNER JOIN associates activities_user nameid on
chronology.acti vities_username id=activities_u sernameid.id
WHERE chronology.upca rd_id = 18"

[Moran Ben-David]

which database server are you using (sql server, oracle, db2)?

"Ike" <rx*@hotmail.co m> wrote in message
news:xb******** ***********@new sread2.news.atl .earthlink.net. ..

For some reason, I have a rather large (to me) query, with numerous inner
joins, accessing a remote server, and it is taking about twenty times longer than most queries to the same database.
The query itself is built programmaticall y within my application, and
example of which is below. I am hoping someone in the group may have some
insight into why this query is so slow, suggesting perhaps a better
structure for it, such that I can go back in and rewrite my code that
creates such queries.

Thanks in advance, Ike

"SELECT DISTINCT
chronology.id,s tatus_id.status ,chronology.com pleted,chronolo gy.completeddat e ,chronology.com pletedtime,acti vities_id.activ ity,chronology. activities_acti v ity,chronology. activities_atta chment,chronolo gy.activities_a vailable_to_all , chronology.upca rds_firstnamela stname,upcard_i d.id,chronology .feedbackrequir e d,chronology.la ndondate,chrono logy.hasspecifi ctime,chronolog y.datetoperform , chronology.time toperform,chron ology.duration, chronology.week ends,chronology . prefix,statusac tivitieisid.id, associaterespon sible.username, activities_user n ameid.username, chronology.edit Flag FROM
chronology,stat us,activities,u pcards,statusac tivities,associ ates
INNER JOIN status status_id on chronology.stat us_id=status_id .id
INNER JOIN activities activities_id on
chronology.acti vities_id=activ ities_id.id
INNER JOIN upcards upcard_id on chronology.upca rd_id=upcard_id .id
INNER JOIN statusactivitie s statusactivitie isid on
chronology.stat usactivitieisid =statusactiviti eisid.id
INNER JOIN associates associaterespon sible on
chronology.asso ciateresponsibl e=associateresp onsible.id
INNER JOIN associates activities_user nameid on
chronology.acti vities_username id=activities_u sernameid.id
WHERE chronology.upca rd_id = 18"