wery slow query

18 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 )

orientd wer wery slow response.   how can  I do ?
Reply all
Reply to author
Forward
0 new messages