SOT: SQL Multiple Inserts

[brobborb]

Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.  Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?  Right now it is just one query looped 5,000 times.

Also are there any drawbacks with using multplie inserts?

Thanks

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---