Faster
Just curious, perhaps it's just a habit thing, but I'm wondering if one if faster than the other? Code:
myVar = "blah"
If myVar2 = "go" Then myVar = "not"
OR
Code:
If myVar2 = "go" Then
myVar = "not"
Else
myVar = "blah"
End If
View Replies
I have a page that does a fairly simple "Select * From Table" I then go through and assign each column a variable, print that variable out in a nice neat table, then do a rs.movenext, then Loop.
This method worked GREAT with my old DB which was 600 rows or so, but now I am doing this against a much larger db (5 to 6 thousand rows) and the performance is very bad. Infact it now takes several minutes for the whole page to render.
There HAS to be a better way to do this? What do you guys do if you have a DB with 5k or so rows and you want to put all that in a table? Should I look into using Java Script? and abandon ASP/HTML?
I am making a Purchase order system for a person who has been using an XLS for several years. She wants to be able to scroll up and down to see all of the POs, which I can do with a smaller DB.
View Replies
View Related
If I separate my search form asp and my results asp into two pages, will that make the search faster?
View Replies
View Related
I currently have the following code to extract data and display in a table.
-Sample code ---[Ranges from 1 to 205] #20 is displayed below]]-------------
Dim ticket20, sql20
Set ticket20 = Server.CreateObject("ADODB.Recordset")
sql20 = "SELECT * FROM routingdata WHERE ddate = #" & Session("today") & "# ;"
ticket20.Open sql20, db, adOpenForwardOnly, adLockOptimistic
While Not ticket20.EOF
Response.Write "<font size=2>" & Ticket20("20")
ticket20.MoveNext
Wend
ticket20.Close
There is 200 plus cells that it need to display - so it takes a long time to display the data. Is there a better code to extract all this data and faster ?
View Replies
View Related
I'm using xmlhttp to get info from 10 different sites.. 1 site's info is coming to me about 3 second. but when i use 10 sites it longs about 30 seconds.. how can i make it faster ... any solution or any different method can you offer me?
View Replies
View Related
I remember reading somewhere that there is a faster way to retrieve a large recordset to display it in a table, could anyone point me in the right direction.
View Replies
View Related
What is a faster/better coding practice?
Method 1:
Code:
Sub myFunction(byRef x)
x = x + 1 ' do something with x
End Sub
x = 7
myFunction(x)
response.write x ' shows 8
Method 2:
Code:
Function myFunction(x)
myFunction = x + 1 ' do something with x
End Function
x = 7
response.write myFunction(x) ' shows 8
Also discuss considerations when there are more than one variables that need to be changed.
View Replies
View Related