On Tue, 23 Jul 2002, Fabio Serra wrote: > 2) <cfqueryparam> is useful when you have to do a lot of insert with the > same SQL statement because it is parsed only one time and the database can > compile the query for later reuse. > But <cfqueryparam> has not the same performance on all databases, instead > if it's not well supported could slower the performance. In Oracle it can > boost the performance, but in Mysql and PG I've never read something similar.
Short comment about the driver, it's the jdbc driver going against mysql or postgresql, so... not sure who's responsible for what. Secondly, I do use cfqueryparam with MySQL -- I don't have anything in the way of speedtesting, but I personally think I've seen a slight performance gain, if not ... a peace of mind from attacks, escaping characters, etc. ~Todd -- ============================================================ Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator) | http://www.ultrashock.com/ - webRat (Back-end Moderator) | ============================================================ ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
