How To Speed Up Code
I'm using get rows to build a table for a calendar. The specific view for this calendar is for an entire month. Each appointment slot is one half hour long. If I were to generate a page for the month of november I would have to check and see if an appointment is scheduled for each appointment slot throughout the entire month. this is 240 slots! At this point I've written it so it only checks for an appointment if a particular day has an appointment, even so, with only 20 or so appointments scheduled for the entire month, it's taking several seconds to return the results.
I was thinking it might be best to pay a javascript programmer to write a script that will parse through the whole mess to offload it onto the client. What would you recommend?
View Replies
ADVERTISEMENT
If I want to get the number of rows returned from the database along with the contents, I would assume that GetRows() would be the best way, and then doing a UBound(myArray,2) + 1 would be the best way to give me the number of records.
If I do NOT need the actual database info, but I just need the number of rows, should I use GetRows or COUNT(ID) in my SQL or what?
View Replies
View Related
my asp pages use mysql db...i got 40 tables.
mostly the site system uses 7 tables only...
in the past i used access mdb database but after this 5 tables fulfilled with something like 10000 records it was so slow i could read a book before it moved...
then i moved to sql...
now the question is for who had/have asp pages connected to mysql with more than 50,000 records...
how is the speed? can you see the speed diffrence with the growing of numbers of records?
if i got slow speed when i ask my asp pages to show me some records, is that because i got more than normal number of records inside one table?
80,000 records inside one mysql table sounds to you normal?
View Replies
View Related
I am about to implement an online auction system similar to ebay. I am debating between two products. One is PHP the other ASP (PHP Auction and Rainworx).
I typically like PHP better, because I've noticed ASP always seems to turn up an error (even on professional sites), but the ASP system has more of the features that I need.
Can anyone tell me the pros/cons of ASP vs. PHP? My largets concern is speed. Is ASP fast? and is it reliable? I've heard something about the code breaks down over time, etc.
View Replies
View Related
I are there ANY secrets in sql 2000 to speed up this process on the webpage? I tried using indexes... expanding the timeout... it is still too big and we cannot archive any records.
View Replies
View Related
The code below is searching a ms access database that contains approx 53,000 records. This code go's into the data and extracts the files pertaining to this customer but the scripts takes approx 40 + seconds to search. Is there something different I can do to speed up the process ? Code:
Dim rs, sql
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT Left(CUSTNOITEM, 4) as CustNo,Right(CUSTNOITEM, 9) as CustNoI,CLASS,descrip,SEQ_NO FROM ARCPRICQ WHERE Left(CUSTNOITEM, 4) = '" & Session("login") & "' ORDER BY " & Mysort & " ;"
rs.Open sql, db, adOpenForwardOnly, adLockOptimistic
While Not rs.EOF
View Replies
View Related
currently using an asp upload to upload file into server, but finding it the transfer speed quite slow, anyone know the faster way or script to upload file into server in asp? or in other language?PHP?
View Replies
View Related
Just wondering if anyone knows how to determine someones connection speed in asp the reason for this being so i can redirect the user to a different media file depending on their connection speed.
View Replies
View Related
is any idea to find client connection speed like google analytics report on connection?
View Replies
View Related
if a page always have some picture that totally have near 250k does this a main point of affect the loading speed?
View Replies
View Related
This page takes awhile to load which is probably due to the queries and the way I have it outputed. Anybody have any advice for speeding this up? Code:
View Replies
View Related
i m trying to write a script for sending email to many people at a time and i m getting the email addresses from database .my script is working but after sending to 8 or 9 people script timed out.
now how can i increase the speed of sending email almost to 60000 people.my script is here.
View Replies
View Related
I'm pretty sure this is possible in ASP, something about making CPU time markers and then taking the difference and switching it into seconds/minutes I just don't recall how to go about doing it.
View Replies
View Related
I'm looking for sample code that will require a use to enter a code from a scued image format.
I'm sure you've seen them before where the image is barely readable by a human and the user has to enter the code correctly to submit the form.
I'm looking for ASP code and NOT ASP.NET code as I am supporting a legacy site.
View Replies
View Related
do you know of any asp code that makes a pdf on the fly.
if there's none do you know of a good, not-so-expensive and easy-to-implement component?
View Replies
View Related
Is there any way that I can store my ASP code in an Access DB and have it display that way? Ideally, I would like to make a page with a text area that I can write and edit code in, and then when I submit it, I would like to view the page that the code creates. The code in the DB would include code that selects from and updates the DB.
I would like to do this because I can't work remotely now.
View Replies
View Related
What is wrong with my code?
This is the error.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CLASSDATE >= 6/23/2004 ORDERBY CLASSDATE'.
This is the code.
Code:
strSQL = "Select * FROM WellClass WHERE CLASSDATE >= " & DATE & " ORDERBY CLASSDATE"
View Replies
View Related
I am trying to follow the W3Schools tutorial on the XMLDOM object, and it works fine in a regular HTML document inside <script> tags (vbscript), but I am trying to do it in the ASP tags (<% %>) and it does not work.
The error says:
Code:
Microsoft VBScript runtime (0x800A01A8)
Object required: '[object]'
View Replies
View Related
I am trying to do something with it and I can figure out what to do!I have created a database that lets realtors track clients, potential clients, and offers made. Here is a link to the database:(URL address blocked: See forum rules)
What I am trying to do is create a form that lets a user enter his first name, last name, email, and offer amount into textboxes. When they click send it adds their information to the Potential Buyer table (the primary key is an auto generated number.) The offer table is basically an associative table, containing the following information: buyer$buyerid, client$clientid, and amount. I would like the amount to be added to this table, and I would like it to also add the newly created buyerid. My problem is that well, I have no idea how to do this, as the buyerid is created only seconds before I need to post it in the offer table. Could anyone help me out with this? I'd really appreciate it.
View Replies
View Related
Im a novice with ASP and no idea of PHP, can Any one help me convert this to ASP...
$rss = $_GET['rss'];
if ($rss && $rss != ""){
if ((strpos($rss, "http://") === 0) || (strpos($rss, "https://") === 0)){
readfile($rss);
}
}
View Replies
View Related
Here's the current code that I'm using for navigation through some pages. MY question is, I want the item "System-Add Ons" to still stay bolded if I'm on a page that's in a subset of "Products" Is this possible?
For example, if a user gets to the page "Monitors," (monitors.asp) I want System-Add Ons to stay bolded....
How can I set up subsets of the "Products" page? Do I have to make a directory and do a test if the page is in the directory "Products" and is affiliated with "Products?" Code:
View Replies
View Related
how to get the content or information of other web site using asp code.
View Replies
View Related
is there any way in asp to execute a pop-up window when a condition in an if statement is satisfied
View Replies
View Related
I Wanna to know that which of below codes related to
ADO within ASP (VBscript) is better?
CODE ONE ::
rsEduCalender.CursorLocation=3
With rsEduCalender
if .State=1 then .Close
.Open SQLstr,cn,3,1
End With
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''
CODE TWO::
With rsEduCalender
if .State=1 then .Close
.CursorLocation=3
.Open SQLstr,cn,3,1
End With
View Replies
View Related
figure out what the ASP code is to email a form?
View Replies
View Related
i created ASP page for Online TEST
it Consist three pages
First Page is Selection of Topic and Number of Questions from List Box.
Second page is shows the Questions as per the Selection in previous page Datas from the Database.
Third Page is Result Page.
But My problem is in Second Page, because all the question are created dynamicaly so that how can i get the User answer
I get the question id and correct answer for all the questions.
but i need to get the user answer for Result.I attached my code for the second page.
View Replies
View Related
Is there a program or website that will validate my asp pages?Kind
of like how html pages can be validated on
http://www2.imagiware.com/RxHTML/ and on http://netmechanic.com
View Replies
View Related
this is what i am doing for zip codes
i want user to enter zip codes like this
92274
92274-0965
so if the user enters zip code like this 92274 then its right
but if he enters zip codes like this 922740965 then change it to 92274-0965
this is what i have done so far so i have got the values of first 5 i need to include a -and then the rest of the numbers any idea how to make this work
View Replies
View Related
I need some code to test whether my connection is open in an asp page. Something like this:
<%
IF NOT connection is open THEN
Connection string code here
END IF
%>
I know how to write the connection string, it's the first part of testing whether it's closed or not that I don't know.
View Replies
View Related
I have two tables, raceresultsview and jockeyselections.
In jockeyselections, I have jockey names and stableid, for example Pat
Day, stableid 1000.In raceresultsview, I have jockey names, and placement.
I want to do something like this:
select * from raceresultsview where jockey in (select jockey from
jockeyselections). This works FINE, but I need to figure out how to grab
the stableid, too.Each time there is a match, I want to insert the stableid and placement
into the table named winnings.
View Replies
View Related
in 3 tier wed based application ..i want to run my vb code seprate for debug purpose...how can i do this>
View Replies
View Related
Heres my for next loop. Basically it is pulling files from a folder. Now I want it so that if it reaches the end of all of the files, that it starts over at the beginning. Any ideas? Code:
View Replies
View Related
This what I am doing:
Moderator (from admin) will see a list of cities to approve/decline.
If approved, then the city will show up in the search and alert city list
boxes.
If declined, then the moderator will be asked to pick an approved alternate
city and all postings containing the user-inputted city name will be changed
to the alternate approved city name.
The moderator will be notified via email when not listed is selected.
Any one have any ideas on how to build this in ASP? I'm kinda new to this
ASP programming thing.
View Replies
View Related