Coba ke www.benpinter.net di folder database ada artikel tentang ini, saya yang buat. Jadi sekalian mohon tanggapannya.
--- primawan <[EMAIL PROTECTED]> wrote: > Maaf mas baru sempet buka email ( abis luar kota ), > makasih atas saran dan > infonya. > > Akhirnya saya pake temporary table dan temporary sp > di ms sql. > > > > Thx > > > > _____ > > From: [email protected] > [mailto:[EMAIL PROTECTED] > On Behalf Of Purwedi Kurniawan > Sent: Wednesday, 28 December 2005 5:03 PM > To: [email protected] > Subject: Re: [Programmer-VB] T-SQL Server 200 > > > > 1. lebih cepat query dg stored procedure > > > > pada waktu pertama kali dibuat, sp akan > dioptimalkan, query plan-nya di > compile dan dibuat cachenya di server. nanti pas sp > dipanggil lagi, yg > digunakan adalah data yg di cache. > > terus ini jg ada hub-nya dg network transfer, kl > pake sp, kita cuman ngirim > perintah buat execute sp tadi, sedangkan kalo query > langsung dari vb, > perintah yg kirimkan bisa panjang dan bolak-balik - > tgt querynya c - > > > > coba di google lagi d mas, aku dulu mbahas ini di > tugas akhir waktu jaman > kuliah, jd udah lupa2 ingat :) > > > > 2. kayaknya bisa d > > > > best regards > > [wwn] > > On 11/1/05, primawan <[EMAIL PROTECTED]> wrote: > > Salam kenal > > > > Halo rekan2 programmer, > > Saya ingin bertanya > > 1. jika melakukan query coding di VB dan query > dengan store procedure di sql > server 2000 apakah ada bedanya. > > Dalam hal ini saya ingin tahu masalah kecepatan > query > > > > 2. parameter di store procedure bisa nggak dipake > misalnya untuk > > - Select top @top percent .. > > - select * from @namatable .. > > Saya sudah searching di help sql dan mentok. > > > > Sebelumnya saya ucapkan terima kasih. > > > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > > > > > SPONSORED LINKS > > > Programmer > <http://groups.yahoo.com/gads?t=ms&k=Programmer&w1=Programmer&w2=Indonesia&w > 3=Basic+programming+language&w4=Computer+programming+languages&w5=Programmin > g+languages&w6=Java+programming+language&c=6&s=157&.sig=QQ3jf-qPyCuDVOqmjxXL > qQ> > > Indonesia > <http://groups.yahoo.com/gads?t=ms&k=Indonesia&w1=Programmer&w2=Indonesia&w3 > =Basic+programming+language&w4=Computer+programming+languages&w5=Programming > +languages&w6=Java+programming+language&c=6&s=157&.sig=gwDT36aV8hG5doSQaoUwS > A> > > Basic > <http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&w1=Programme > r&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+languag > es&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=g8R4 > hday0lm5D2hL5lG5aQ> programming language > > > Computer > <http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=Progr > ammer&w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+lan > guages&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig= > RLdM7FZAm3K7raX0D8KsjA> programming languages > > Programming > <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Programmer&w2= > Indonesia&w3=Basic+programming+language&w4=Computer+programming+languages&w5 > =Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=CtRXYvnoy > 1O17UC430cphA> languages > > Java > <http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Programmer > &w2=Indonesia&w3=Basic+programming+language&w4=Computer+programming+language > s&w5=Programming+languages&w6=Java+programming+language&c=6&s=157&.sig=XQJC4 > fZro9pIX1bkqBwT8w> programming language > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "Programmer-VB > <http://groups.yahoo.com/group/Programmer-VB> " on > the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > * Your use of Yahoo! Groups is subject to the > Yahoo! > <http://docs.yahoo.com/info/terms/> Terms of > Service. > > > > _____ > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> 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/
