kalau buat proses update atau insert, sebaiknya jangan menggunakan object recordset mas, lebih baik cukup pake methode executenya objectconnection (objConnection.Execute) atau pake object ADODB.Command. gunakan object recordset hanya u. query yg memberikan kembalian recordset (spt select).
**** Start Here ******
dim con as new adodb.connection
...
.....
Private sub cmd_Simpan_Click()
for i= 1 to 1000
con.execute "Insert into nama_Tabel values('" & i & "')"
next
end sub()
dim con as new adodb.connection
...
.....
Private sub cmd_Simpan_Click()
for i= 1 to 1000
con.execute "Insert into nama_Tabel values('" & i & "')"
next
end sub()
On 3/16/06, denkdeng <[EMAIL PROTECTED]> wrote:
Hello vbers..
Kenapa ya kalo aku update atau insert ke database semakin lama
semakin lambat..
misalkan codingnya seperti ini
**** Start Here ******
dim con as new adodb.connection
dim as new adodb.recordset
...
.....
Private sub cmd_Simpan_Click()
for i= 1 to 1000
rs.open "Insert into nama_Tabel values('" & i & "')",con,1,3
rs.close
next
end sub()
****** End ************
ketika di eksekusi, proses insert/update-nya semakin lama semakin
lambat. kenapa ya?...
Kira-kira ada yang tahu nggak gimana caranya update atau insert
dengan looping secara cepat..
mohon pencerahannya dari teman2.. terimakasih
regards
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
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
