Good Execution Time
I have written a few functions that are used on several pages throughout my site and am wondering what a good exection time might be (generally). The inital page a user is faced with after logging in pulls data from several different tables and displays 40 rows all together.
The execution time for this particular page is the slowest at approx. 950 ms to 1400 ms.
This seems awfully slow. This is probably because I am executing 10 different stored procedures instead of one (I thought it would be too big of a challenge to write a single select statement and parse through all the data). What sort of execution times are acceptable to most of you? What do you usually shoot for?
View Replies
ADVERTISEMENT
Any some tools or sample codes drop down asp script execute time and
database connection time ?
View Replies
View Related
Timed Execution for Access Database?
I was reading a book about access databases and sql, when i came upon the time execution part it simply said it could be done but did not go into details as to how. Does anyone out there know of a way to produce a time execution with a access database?
ex: ability to set an email to be sent out on the 1st of january at 5pm, and on that date/time it would send it out. I know that you can simply have a asp page check the time when opened and if it's the correct time use a function to send it, BUT is there a way to do it with out having to go to the page on that time???
View Replies
View Related
Basicly, when the page is in bad performance, the user will feedback to me, and later I tune it for better performance.
Is there any way or software to trace all the ASP pages' execution time in my site, so that I can tune it before user's feedback and have an overview of all my pages execution?
View Replies
View Related
how do i get the time spent for an ASP script to execute ?
View Replies
View Related
Is there an easy way to determine how long it took a particular page to execute?
View Replies
View Related
I'm writing an application which allow user to manage several mobile/fixed line accounts. The situation that I have now is this:
1) User choose the accounts that he want to manage (it is unlimited number of accounts, could be only 1, could be 1000, could be 10000)
2) He choose from a variety of actions to perform, in my scenario, I'l say he wanted to make changes in the Value Added Service (VAS) section (this is the part that takes the longest time to process the script, there are 27 options in this section)
3) The user will then choose whether he wanted to ADD or CANCEL the VAS that will affect all the previously selected accounts and click on submit.
4) My script will then check whether this user did any transaction before on the same day, and whether if he did the exact same action (says this morning he had perform VAS - ADD to an account, he can't do it again on the same day)
5) If no error detected, my script will then insert all the records into tables.
Now, my biggest problem is in task 4 and 5. These 2 part take the script a very long time to execute. For a transaction that have 50 accounts, it will take me about 72 seconds to have it complete and a staggering 602 seconds when I tested with 500 accounts.
I tried to use MSSQL indexing features but it doesn't seems to work the charm for me or maybe I did it the wrong way. What happens in my script during Task 4 was checking throught VAS Transation table for each selected accounts. This means my loop look something like this: Code:
View Replies
View Related
Does anyone know of any good ASP books in PDf format?I am new to ASP and I would like to do some reading on the subject.
View Replies
View Related
Most of my ASP programming experience is on NT4.We recently upgraded (replaced) our NT4 webserver with Win2k3 Web Edition.I am looking for a good book that I can go through that will show me the new and different ways IIS6 does things. I found out that some things still work from my old web site, but they no longer work on the new site.
View Replies
View Related
I've been doing ASP by hand-coding in either Homesite or Interdev for years. I have been using Dreamwever for static sites that I make on the side. I recently was asked to make a form which will store info in an Access database, and thought it would be a good chance to learn how to use Dreamweaver MX's ASP capabilities.
Haven't tried it yet, but reading up on it, it seems that it forces you to use Session variables. I'm not a big fan of session variables, and want to avoid them. Anyone here use DW MX for ASP?
View Replies
View Related
This questions is a little one sided, I used to have the connection to the database on the site until I learned about the global.asa and since then all my sites have used it. I don't know the benefits of this file vs any other methods so I have to ask. But first let me explain.
I have a site, one of the many using the global.asa, it works 2 Microsoft access databases that run pretty much simultaneously on the site. Today, my host sends me an email telling me that they are open constantly and it's causing them problems on their shared server. So I modified the asa to close the database after every session and the host I had done so. They replied shortly after saying that a session could be open for 20 minutes before closing and they did not see this amend as helping the problem. So I'm looking for an alternate method.
The site itself is a collection database with over 1,200 user accounts, I have absolutely no idea how many of these user accounts are actually in use, but that is how many registered users there are in the database. Most of the regular users probably visit every day or two and I know that the admin (of about 8) visits daily to update the records unless there is nothing to add.
I've been given 7 days to solve this problem or they will close this particular site down. So in this case, is global.asa a good idea? If not, what method could I use to minimise the database being opened?
View Replies
View Related
I need to learn ASP. Can anyone recommend a good ASP book for me. Also is there a good ASP manual online such as PHP.net for PHP.
View Replies
View Related
I am an intermediate ASP programmer looking to start learning .NET and am
looking for a good book to start learning from. Anyone have any
recommendations on a good book to get me started?
View Replies
View Related
Can anyone find fault with this code? I wrote in in hopes of preventing users from "breaking" SQL queries and getting places they shouldn't by using SQL Injections.
Code: ....
View Replies
View Related
Ive been making asp sites for about 2 years, but my first "real" site is going to be going live soon. Im currently seeking out a reliable hosting company based in england to host this website. Has anybody got any ideas of a good host? Ive been searching around for some time, but have not come across any that looks good enough. Im not after a dedicated server, shared hosting will do.
View Replies
View Related
I looking for a tutorial on charts/graphs which would take information from the DB table. I have a column about 31000 records and numbered field of 001-0022. I hav another field which contains texts.
What I'm looking for is to show graphically on a scale of 001-022 as in the first field how many time does the search criteria appear.
For example: I search a keyword "hello"
and the graph would show 001: 30 times, 002: 4 times...022: 1 time, but as a chart.
I think it would be nice to add a percentage calculation too.
View Replies
View Related
I'm looking for some script sites that do things like ecards, calenders, journals etc. Do you know which are the top 3 for ASP?
View Replies
View Related
I am trying to send out a mass email newsletter. I have 600+ subscribers in our SQL Server Database. Well, is ASPMail (Server Object's product) good for this? If so I have some concerns about the error handling and assuring people don't continue to recieve the same email. Does anyone have expierence with this? If so, what is your advice?
View Replies
View Related
Since my efforts to get my current script working are not working out. Does anyone know of a good ASP form handling script that can work with my HTML form.
View Replies
View Related
From the research that I've done so far, it appears that most of the Free Forum software out there, is designed for a PHP environvent/back-end.
Well, I know nothing about PHP (and dont have the time or desire right now to learn it), but I do know a thing or two about ASP.
I was wondering if anyone could recommend a good FREE ASP based Forum software. ????
View Replies
View Related
Does anyone know of a good yet simple shopping cart written in ASP? It doesn't have to be free I am willing to pay up to $200. I am just looking for a simple front end and an admin area to add products easily.
View Replies
View Related
i get some data from a session variable.(the session variable gets this data from another page).I want to display the data in a formatted manner.
View Replies
View Related
I'm looking for a good web-based calendar that I can host on my website. Some features I'm looking for are the ability to schedule birthdays, anniversaries, etc.
with email notification of when the event is nearing. Picture uploads are something else I'm looking for. Easy to read and easy to maintain is also a plus.
View Replies
View Related
I want to plot a bunch of curves on a graph. Each curve will be
defined by 10-20 (x,y) points. The points can be connected by lines.
Preferably (though not necessary), I would like to be able to select
the line or curve so I can identify it in a text box below the graph.
Does anyone have a recommendation for ASP code or a component to do
this?
View Replies
View Related
I'm trying to get some recommendations on credit card authorisation suppliers such as paypal, worldpay or 2checkout.
Seems like a bit of a mine field so wondering if anyone has any view, positive or negative on these (or other) suppliers.
I notice paypal is free but chargers about 3% or the goods sold which isn't bad for a small startup. I think Worldpay is about 2% but charges a monthly fee.
Is it easy to get this up and running on a site? do you connect to theirs to do the payment or just fire secured data to them to process? is one a better deal, safer and easier to implement than another?
View Replies
View Related
An ASP script written in ASP.NET has worked fine on one computer, and since it has been moved to another, it doesn't.
The part that does not work deals with executing CMD.EXE. Here is a part of the code:
System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo("cmd.exe");
psi.UseShellExecute = false;
psi.RedirectStandardOutput = true;
psi.RedirectStandardInput = true;
psi.RedirectStandardError = true;
psi.WorkingDirectory = @"c:SOME PATH";
System.Diagnostics.Process proc = System.Diagnostics.Process.Start(psi);
System.IO.StreamReader sOut = proc.StandardOutput;
System.IO.StreamWriter sIn = proc.StandardInput;
sIn.WriteLine("SOME COMMAND LINE PARAMETERS");
...and instead of executing like it did on the last server and displaying the output, it creates a web page with the following output:
Microsoft Windows [Version 5.2.3790]~(C) Copyright 1985-2003 Microsoft Corp.~~c:SOME PATH>SOME COMMAND LINE PARAMETERS"~~SOME PATH>EXIT
...followed by the rest of the web page as it did before.
What I figured is that for some reason this script on the new server instead of executing the command, it just sends it as an output to HTML.
I have tried to readjust .NET security, then to adjust the folder permissions (I gave EVERYONE permissions to all the needed folders). Nothing helped.
View Replies
View Related
I have got a problem executing a query. The driver indicates an error in Internet Explorer : No value given for one or more required parameters It refers to the recordset definition. I have tested the query in my DBMS, it works.
SOURCE :
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " & server.mappath (BDname) "
Dim StrSQL
StrSQL = " SELECT NOM FROM ATTRIBUT WHERE LIBELLE = TRUC"
Dim rcdSet
rcdSet = Server.CreateObject("ADODB.Recordset")
rcdSet.Open StrSQL, objConn , adOpenForwardOnly, adLockPessimistic
View Replies
View Related
I am greeting I would like to consult the better solution(with security consideration) to
the access is for MSSQL(2005) from ASP(Classic) in the system of the intranet.
a) SQL mixed mode and depositing user name and passwords for MSSQL of the
server in "connection string" (with open text)
b) Windows Authentication and to send rights to SQL of the server for
IUSR_computername
c) ?
Intranet(server ASP and MSSQL) in the company available from the any
computer, workers data (name and pass) they are being kept in MSSQL tables.
Problem is because Server MSSQL(Intranet) he will be replacing himself into
data with two MSSQL servers and with one PostgreSQL through Windows
Authentication.
View Replies
View Related
I currently have an asp page that ask for an email address and then with selection values runs a stored procedure.
Everything runs fine but the concern is that with enough records the processing limit will be exceeded by the web server and it will cause the page to crash.
Is there a way with ASP and MSSQL to send a request to process a stored procedure but have the processing of the asp continue while the sql runs its cousre? My sp will already email the user when processing is complete I just need the asp to send the request for it to be run but not try and run it while the next page loads.
View Replies
View Related
The statement was made that the following code works.
Is This ture?
stringa = "response.write 1"
Execute(stringa)
View Replies
View Related
Is there a way to execute sql queries besides using recordset? If so, can someone provide me with links to materials i can read online or post an example?
View Replies
View Related
I have an asp page that contains a simple insert statement and redirect i.e.:
Page1.asp
<%oconn.execute "insert into table 1 values(1)"
response.redirect "newpage.asp"
%>
I have to add some code to it to not allow execution of this script if the page was called from the <img> tag i.e.
<img src=http://webname.com/page1.asp width=1 height=1>
The page should be opened in browser in order for the script it contains to be executed. How do i acomplish that?
View Replies
View Related
i do have a little problem.....i have 2 difrent functions in my asp pages. function1 and function2.
funktion 2 has to be executet 15sec after function 1 had been executet.how can this be solved in ASP, and is it impossible.
View Replies
View Related
