performance

Hello,

I have problem with performance of specific select on Cloud. Same
select on same database on local took about .5 sec. I had only one
successful run with time about 88 sec when I did it against Cloud. All
other attempts fail.

instance: appsres:appsres

problematic command:

SELECT COUNT(distinct ao_id), templates.*
FROM application_templates, templates, aobjects
WHERE appt_app_id=1 AND t_id=appt_t_id AND ao_ot_id=t_ot_id
GROUP BY t_id, t_code, t_name, t_desc, t_ot_id, t_ta_id, t_user_id
ORDER BY t_name

successful commnad (.5 sec):

SELECT COUNT(distinct ao_id), templates.*
FROM templates, aobjects
WHERE ao_ot_id=t_ot_id
GROUP BY t_id, t_code, t_name, t_desc, t_ot_id, t_ta_id, t_user_id
ORDER BY t_name

table application_templates has only 5 rows.