primary key nya column yg mana? tabelnya ada index on E? coba sql dibawah dijalankan dan lihat hasilnya berapa... select count(1) from (select E, count(1) aa from ABC group by E) where aa > 1000;
On 3/30/07, evi s.r. ( PRD - Datacom Solusindo ) <[EMAIL PROTECTED]> wrote: > > RAM nya 512MB. > > SQL nya bervariasi sih, sudah dicari cara optimalisasi dengan menggunakan > index dan cukup membantu. > > Misalnya, kalau sumber data masih sekitar 100 ribu, proses query bisa > sekitar 3 detik. > Tapi begitu jumlah sumber datanya sudah ratusan ribu, langsung drop. > Kadang sampai 30 detik atau lebih dari 1 menit. > > SQL nya contohnya gini : > > select > cast(substr(A,1,3) as signed) AS A, > sum(B) AS B, > sum(C1 + C2 + C3 + C4 + C5 + C6) AS C, > sum( case D when '0' then (X1 + X2) else 0 end ) AS X, > sum( case D when '1' then (Y1 + Y2) else 0 end ) AS Y, > sum( case D when '2' then (Z1 + Z2) else 0 end ) AS Z > from ABC > where (E = '0702') > group by substr(A,1,3) > > Yang saya ingin tau, cara pengaturan variabel di server untuk kondisi data > besar sebaiknya seperti apa? > > Lalu apakah penggunaan parameter "sql_no_cache" dalam sql berpengaruh? > > btw ... ndak apa kan nanya tentang database di forum ini? > > thanks > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
