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] -- 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/
