wery slow query

31 views

Skip to first unread message

Salih DÜZEN

unread,

Dec 1, 2021, 2:00:44 PM12/1/21

to OrientDB

select surveyname, thequestiontitle,answertitle,sayi,tcevapsay,oran,floor((oran/tcevapsay)).append('%') as sonuc from (select surveyrid.surveyname as surveyname , thequestiontitle , answertitle , count(whois) as sayi, $a[0].tsayi as tcevapsay, (count(whois)*100) as oran from questionresult let $a=(select count(thequestiontitle ) as tsayi from questionresult where thequestiontitle=$parent.current.thequestiontitle) where thequestiontitle is not null group by thequestiontitle,answertitle order by thequestiontitle,answertitle )