Database Discussion

Print Page | Close Window

Insert

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4388
Printed Date: 30 March 2026 at 5:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Insert

Posted By: Boecky
Subject: Insert
Date Posted: 20 July 2003 at 3:52pm

What do you think it's the best way to insert data into a database? (the most optimised way) Just do it with open a connection and do the insert sql? Or via a recordset (insert sql in a recordset and then update)?

Replies:

Posted By: MorningZ
Date Posted: 20 July 2003 at 3:59pm

regardless of which way you do, unless your site is super duper high traffic, you aren't going to notice a difference in performance

as for personal preference, i like to use embedded SQL ("INSERT statement") or a Stored Procedure to do an insert.... kinda gives me practice using/learning SQL instead of depending 100% on ASP methods

-------------
Contribute to the working anarchy we fondly call the Internet