|
-
1. make sure they are using bound variables. You want to make sure oracle is not parsing each and every insert statement.
2. Use array inserts. Insert a bunch of stuff at one time instead of multiple writes.
3. Use sql*loader. You can bypass oracle's buffer cache and insert directly into tables.
(I don't understand why people always try to re-invent the wheel. Spend your programmers time on application logic & GUI's.)
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|