Database view does not work with left join

[Tam_s Ujj1]

Hi,

Any idea why this database view does not work with left join? It times out with left join but works fine when not using left join. Report contains 70K entries sys_portal_preferences contain 700K.

sys_report	100	report		false
sys_portal_preferences	200	pref	report_sys_id = pref_value && pref_name = 'sys_id'	true

[AndersBGS · Accepted solution]

HI @Tam_s Ujj1 ,

I'm pretty sure it's due to the large amount of data when doing a left join - It will properly work if you can norrow in your search criteria. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Tam_s Ujj1]

Thanks, I came to the same conclusion even though I narrowed down the sys_portal_preferences to 70K it still timed out.