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


ADVERTISEMENT

Faster Way

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

Faster Search

If I separate my search form asp and my results asp into two pages, will that make the search faster?

View Replies View Related

Display Data Faster

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

How Can I Get Info More Faster With Xmlhttp Or Any Other Methods?

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

Faster Return Of Large Recordset

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

Returning Values - Which Is Faster? ByRef Sub Or Value-returning Function

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







Copyrights 2005-15 www.BigResource.com, All rights reserved