execute question...
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=455
Printed Date: 29 March 2026 at 3:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: execute question...
Posted By: skyworld
Subject: execute question...
Date Posted: 23 February 2003 at 5:37pm
|
whats better using objConn.Execute "UPDATE UniqueIPs SET Visits = Visits + 1 WHERE IP='" & ip & "'"
or strSQL = "SELECT * From ip where ip like '" & IPADDRESS & "'"
and which is faster ... btw im using it for multiple connections. ..
|
Replies:
Posted By: Bunce
Date Posted: 23 February 2003 at 8:41pm
|
Can't compare. They're different. One updates data and one selects data. ------------- There have been many, many posts made throughout the world... This was one of them. |
Posted By: MadDog
Date Posted: 23 February 2003 at 9:21pm
hahhhaahhaahhaha. skyworld, try researching this stuff instead of asking everyone a million questions!!!! ------------- http://www.iportalx.net" rel="nofollow"> 
|
Bunce wrote:Posted By: nittystone
Date Posted: 24 February 2003 at 9:04pm
|
my top is good. if you often use select you can append index on db often use update and insert ,reduce index ------------- i'm fly to be near you to be free i'm a chinese i want study english in here thanks every obdy |