Is there a way to insert data in bulk? I have come across this problem a few times now. I have a program that reads a bunch of data from a file, or generates, whichever. I want to take a bunch of data and insert it, but I'd like to avoid doing the individual inserts while looping through or whatever. In other cases I'd just like to wait until I have may 10 or 20 rows to insert and do it all at once rather then hitting the database continually.
Is there any solution to this type of problem?
Thanks.