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 RepliesI 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.
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
If I separate my search form asp and my results asp into two pages, will that make the search faster?
View Replies View RelatedI 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 ?
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 RelatedHow can I select only certain records from a recordset using the ADODB functions? I've had a ganders through the W3School ADODB Recordset Reference but I'm struggling to understand all the functions.I was hoping to start and end the recordset from specified numbers eg. records 11-20.
View Replies View RelatedI would like to know about the methods : post and get of ASP.What is the difference between them.
View Replies View RelatedUsing HTTP_REFERER I cannot capture the URL when the link is made via a
button:
<input type="button" name="Continue" value="Continue Shopping"
onclick="ContinueShopping('http://mysite/supertest.asp');">
I do not control the script above, it is on an e-commerce site that is very
generic, meant for many users - and is generated by their server code. I
want to capture the URL and with an if/then redirect if the last place
visited was the checkout site.
I need an alternate method of URL capture, rather than HTTP_REFERER.
I have two submit buttons. The first one ,when hit displays a table on the same page.The next submit,when hit should insert certain elements from the page to DB and go the next page saying "thanks"...
I am not sure how i can achieve this .I want to know some ideas or if it is possible to use to form methods in one page?
I am trying to parse XML returns from a certain website, sent back in response to my URL queries. The root node of the returned XML has a namespace instruction that I cannot get rid of.
Why do I want to do that, you may ask? Well, I' m really a newbie with XML/XLST/XPath and so on, but I know that If I paste the XML return into a new XML document, get rid
of the namespace stuff, and use that page instead of the original XML return, my code works! Below is a sample of my code so far. Code:
i'm needing a different shopping cart method to update an inventory catalog. it uses the dictionary object, stored as a session variable. not efficient, as some has let me know. i know of one other method of building temp tables in the db. are there any other methods that are efficient and scalable?
View Replies View RelatedI am using the following code to create abd use a recordset:
Code:
SET RS = Server.CreateObject("ADODB.RecordSet")
SET RS.CursorLocation = aduseclient
SET RS.CursorType = dymanic
SET RS = cn.execute("SELECT * FROM thistable")
But all I get is the following error:
Microsoft VBScript runtime error '800a01a8'
Object required: 'CursorLocation'
/RUNGE ARCHIVING/default.asp, line 67
which is pointing to the folling line:
SET RS.CursorLocation = aduseclient
If I tafe out that line it will give problems in the line below it, it i delete that it works fine. But I want use to a dynamic recordset. Is there something I typed wrong or a setting I overlooked, or anything on how to fix this ??
What is the best way to encrypt an email?
View Replies View RelatedThe database is used for referencing filename, there located folder, id, order shown, but also there are some fields say "location_1" up to "location_4" which have a 0 , 1 or 2 in them. 0 means that file not needed for that section. 1 means needed for that section, and 2 means mandantory (must be seen before exit).
firstly selecting a location from a html radio box, drop down menu (not decided yet) will return whats needed so not showing pages what aint needed and wasting time.
Here it is though in order on the left i wish it to build a menu, but more advanced than plain links would be good. drop down like windows explorer etc. Code:
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.
I need to get data from a url (which throws out XML) and then parse it using DOM or XSLT. I know, to get the data, I need to use XMLHTTP.
Can I get a sample code for it?
I have the code below and in a random fashion it is responding extremely
slowly. On in 3-4 times it takes ages to do the job..
It is the line: xml_http.Send("") that gets stuck. I am on IIS 6 on Windows
Server 2003 Web Edition. Code:
One of the limitations of ASP is the lack of a dynamic SSI, in which you can include files using variables. So far I know only of two methods to go around that.to use the File System Object.to use the XMLHTTP Object.Which one of the two is less of a burden for IIS ? Or are there other ways that are much better?
View Replies View RelatedI m getting information with XMLHTTP from 3 sites at the same time. but it is so slow. how can i make it faster. any information or any document about it. anyone who know about it. it is about alsa bandwith. how can i increase xml http performance.
View Replies View RelatedI got a great little example of how to use XMLhttp to query an external web site (I'm wanting to do my own localised search engine by extratcing the content and putting it into an Access DB), but it only appear to extract from the page that you point it to, ie the main default page is extracted when you put in something like www.hp.com.
I want the util to extract content from all of the found pages in the site I suppose like a spider. Has anybody done this or any ideas how you get it to go past more than the initial page?
I need the ASP/xml page to send the Request to the share point portal server (Webdav) using XMLHTTP and i also need to parse the response xml into HTML.If any body knows about.
It might contais mainly three files one is Search page where user can type his requirements , second one contains sending XMLHTTP request to the Share Point Portal server and third one contains the Parse xml response into HTML format.
I use MSXML2.XMLHTTP to receive some HHTP responces from
remote server, unfortunatedly, it uses cookie-based auth.,
so I am unable to pass it, due to inability to store
cookies. How can I retrieve cookies from the headers of
HTTP response, and how can I add them to my request at the
next step?
Why do sites dragged in through XMLHTTP only download half or so of the images associated with the site?
View Replies View RelatedUp to this point, i've been able to extract the search results from a site. Form -> Results chain.
However, on a new project im on, im a little stuck, and not sure if it is at all possible. The next page im trying to get info from there's a chain of 3 pages. so Form -> Middle -> Results.
I've tried inputting my own form data, but i get the page info from the Middle link, and not the Results link. Any ideas how i can go on to the Results link?
At the moment i dont think it's possible, but i haven't been in this game for long.
I'm using XMLHTTP to perform a simple screen scraping job.
When I try to have it "scrape" lines with embeded CSS declarations, it
renders them incorrectly, stripping the leading period. Consequently, my CSS
doesn't work.Here's how I'm calling it, but I don't think my implementation is the
problem.
Dim srvXmlHttp
Set srvXmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP")
srvXmlHttp.open "GET", TearURL, false
srvXmlHttp.send()
If srvXmlHttp.status <> 200 Then
Response.Write "No Server Response"
Response.End
End If
Dim strRetval5
strRetval5 = srvXmlHttp.responseText
I have a peculiar problem using the method
Server.CreateObject("MSXML2.ServerXMLHTTP") in order to get a connection
from one server to another.
On my personal host (IIS) the above method works perfect, and I can 'include' an HTTP stream from a remote URL into my own page. However, the method doesn't work on another webserver (IIS, too) although the MSXML2.ServerXMLHTPP method is installed (I checked it).
The error message I get there is:
msxml3.dll error '80072ee2' The operation timed out
This error does only appear if I try to get data from a remote URL, if I try to get data from http://localhost/foo, the method works - I believe the webserver is behind a proxy. Would this cause any problems? And if so, how can it be solved?
- Do you guys know of any other solution how to 'emulate' the php
include command in ASP without using the MSXML2.ServerXMLHTTP method?
Shown below is ASP Code sample that tries to access a method,CreateUser in the server called, "http://smallbutsmart.basis.com.au" using the protocol,XMLHTTP. Can you explain to me why this Code does not work and showing the correct Code Sample?
<%
dim objXMLHTTP
set objXMLHTTP = Server.CreateObject("Microsoft.XMLHTTP")
objXMLHTTP.Open "Post", "http://smallbutsmart.basis.com.au", false
'objXMLHTTP.SetRequestHeader "Content-type", "text/html"
'objXMLHTTP.CreateUser "abc","123","Scriven","1","001","qms"
objXMLHTTP.Send
%>
I've been searching everywhere online to find an alternative method besides
using Microsoft.XMLHTTP (as it freezes the server up alot!!) but with no luck
at all.
I am using server side ASP, and some said to use Microsoft.ServerXMLHTTP
instead. However I have tried that as well and it still freezes up the whole
thing (i.e. the site just keeps loading forever).
I tried to do a "on error resume next" clause to catch the error but still
doesn't stop the page being freezing up.. :(
I saw someone here said don't use XMLHTTP in ASP as it is not thread safe
(is that why it is freezing up??), and suggest to use
MSXML2.ServerXMLHTTP.3.0.
so do anyone know if MSXML2.ServerXMLHTTP.3.0 will help? i.e. not freezing
up the page?
when we get info from an url with xmlhtttp or xml server http how it
behaves. how bandwith it uses or how it adjust the bandwith which it use...
how can it use all the bandwith.. any promramme or any windows adjusment
...are there possible solutions.. for example how the flash get use all the
bandwith when we separate from the whole part a file to lots of part
Is this the correct newsgroup for this posting?
I have a problem when using these lines of code:
Dim xmlhttp as Object
set xmlhttp = CreateObject("Microsoft.XMLHTTP")
Call xmlhttp.Open("GET", Application.Profiles.ActiveProfile.Server &
"/Test.abc", False):
Call xmlhttp.send("");
when the last line of code is executed, i get the following error message:
"The download of the specified resource has failed. -2146697208"
Application.Profiles.ActiveProfile.Server = http://x.x.x.x/virtualdirectory
I have a question regarding async mode for calling Microsoft.XMLHTTP object.
Microsoft.XMLHTTP hangs the IE once in a while suddenly, but it will work
again after half an hour or so without doing anything. I have searched
through the Internet and seems like the reason it hangs the browser it's
because XMLHTTP limits you to two concurrent HTTP connections to each remote
host; so if more than 2 concurrent connections strike the script which is
calling XMLHTTP, it will hang. Is that true?
If that the case, can I change async mode to true (async=true) so that it
will only take one connection at a time, meanwhile other concurrent
connections will loop and wait till XMLHTTP is ready to process data again.
Will that work?
My XMLHTTP request code ran fine then all the sudden I get:
An exception occurred: 'xml.Send'
When i reset IIS it works fine again (for awhile)....
Does anybody know what is causing this problem and how to stop/fix it???