Will ASP Query Be Slow If Field Names Are Lengthy?
I have an Access database with 58 fields in one table. I wrote many
of the field names so that they were descriptive so that others could
figure it out in the future. As an example, one field name is called
MissingPart14990aDescribe.
Should I be worried about the length of the field name? I'm expecting
about 20,000 records a year to be entered into the database. So, five
years from now, which would be about 100,000 records, will the
query.asp for a list of records be slow due to field name size? BTW,
the query.asp would just show a list of the last 3 months worth of
records and only a snapshot of about 6 of the 58 fields.
View Replies
ADVERTISEMENT
I have built input fields inside a while not.eof loop
and the name is built from using <%="name"&i%> and the value is a product_id
from the database.the i is then incremented in the loop, resulting in <input name="name1, <input name="name2
and so on. this works no probs, however i haven't got a clue on how to collect this dynaimcally named
input field when it arrives at the form action address page.
I was thinking some kind of for loop but am not sure, and again am not sure where to put the <%="name"&i%> bit
to count or grab the input fields info.
i.e newname= REquest.Form(<%="name"&i%>)
View Replies
View Related
I have a "csv file" as a database.
The 1st row contains the field names:
Orion.Accounts.AccountName,Orion.Accounts.Address1
the code I use normally works:
<%=rs("Orion.Accounts.AccountName")%>
Although in this case is doesn't because the fieldnames contain full stops.
how to modify this line:
<%=rs("Orion.Accounts.AccountName")%>
View Replies
View Related
Does anyone have a definitive list of keywords to avoid or prohibit as field names for the tables for an ASP driven program that communicates with a SQL database?
I have a website that allows customers to define tables online and I keep hitting the field names I need to prohibit - "Function" is the latest one. I'd like to just compare the users field names with a list and end this problem for good! Also any VBScript words too?
View Replies
View Related
When using RS.getRows how do I go about getting the field names from the database as well?
View Replies
View Related
I am trying to display only certain columns from a table and this is a code that I am using but it is not diplaying anything, can anyone tell me where my code is wrong
<%FOR EACH field IN rstSite1.FIELDS
if field.name ="EmpName" then
RESPONSE.WRITE("<TH ALIGN='LEFT' BGCOLOR='#B0C4DE'>"& FIELD.NAME & "</TH>")
end if
NEXT%>
View Replies
View Related
I am designing a shopping site, in the picture the #1 section is a check box behind product name that customer can select that product to buy in #2 section the customer can set quantity of the selected product ok now codes this is the code which I have used to pull out produts and categoris from database and show them on the page Code:
View Replies
View Related
I tried posting this a minute ago but timed out, so sorry if this is posted twice.
I want to make an IF statement in ASP using VBscript that will run if a checkbox in a form is checked (and won't otherwise). How do i refer to the form field (checkbox) in the IF statement to do this?
View Replies
View Related
Is it valid to get information from a request.form assign that to a value then use that value to get other content on the requested page.
I return a large rs with multiple feild names. I can't use a static feild def because they would overwrite each other on the loop, SO i create dynamic field names then pass the id back to the next page via javascript. I then use that id to add to the feild name to make sure I get the right feild.
Id = Request.Form("Id")
SQL STUFF
CheckedID=Request.Form("Name_"&Id)
View Replies
View Related
I have been provided with a DSN, user name and password for one of my
clients sites.
I'm not an ASP developer and need to view all the contents of this database.
I usually work in PHP but only have ASP available on this server.
I want to open the database and simply output all the contents into a HTML
page.
View Replies
View Related
I do a SELECT * from table command in an ASP page to build a text file
out on our server, but the export is not to allow a field name rows of
records. The first thing I get is a row with all the field names. Why
do these come in if they are not part of the table records? How do I
eliminate this from being produced? Code:
View Replies
View Related
I have a page with a drop down box and a text field. The drop down box selects a column from a table in my database. txtField is the drop down box and txtSearch is the text field.
The form method is post and the results are passed to the next page which has the query for the database as shown below. Anyone any ideas why I get no results from the query? It works in queryanalyzer so I assume its my asp thats wrong? Code:
View Replies
View Related
I'm getting an error when I'm retreaving from a "text field" in the database and it has no data in it. I'm using MYSQL version 3.23.58-nt. I have the same script running a different system and I don't get this error. It justs output nothing and continues with the loop.
This has to be an ASP problem when retrieving data from the database. I've change the Field for Message to "varchar(252)" vice "text" in the database and stoped giving me error. But I still need to use the type "text" in the database since my "Message" will be longer then 252 caracter. Code:
View Replies
View Related
I'm trying to retrieve data on all users currently within our active directory system, and although i have had some success there is one field that i still can't extract the values from - postalAddress. I'm using the following code:
View Replies
View Related
I'm working on a site that is just *extremely slow* on certain pages that are very database intensive. Now... I've worked quite a bit with databases before - and this is different. It's ridiculously slow.
I've looked through the long ASP script (it's a calendar listings page, with some more db stuff under the calendar).
There's not really anything else I can do to fix up the code. I've consolodated SQL statements, converted everything to GetRows... closed my objects immediately... etc. I've also added indexes to the db fields in my WHERE clause of SQL.
The page isn't *that* complicated that it should take so long. Sometime it even time-outs.
I've tried so much, and nothing is working.
Could it be that I need a dedicated server? Something I'm missing in the code? (It's really long so I'd prefer not to post it if possible but I might).
MySQL
View Replies
View Related
I need help with a database problem in asp. When the page runs is is timing out.
THere are 18000 records.
Is there something I can do to make it faster or run on the server side before display?
I have set the timeout to 2400 and it is still timing out
View Replies
View Related
I'm trying to surf on a website on winXP, but IIS response is very slow. It doesn't load a lot of images (red x). Besides, it alerts always there's no connection (from each page to the following), asking whether I want to connect. The browser keeps waiting for images then it fails. What can I do?
View Replies
View Related
I developed a page that takes from the database based on a select information and displays that on the screen. My problem is that the display proces is very slow, it takes time to display the results. Code:
View Replies
View Related
in what condition will lead the the ASP page run too slowing.
View Replies
View Related
I've set up a form which sends info to my email address usind CDO 2000 w/ authentication which takes about 10 seconds for the message to get sent.
View Replies
View Related
I'm connecting to an Access table with 100+ rows of data of approx 20 columns wide. I'm using getstring to "Quickly" display it in a table, but it's un-useably slow.
View Replies
View Related
I have a development box running Windows NT Server 4 SP6a with all the
latest hot fixes and patches. Up until a couple of days ago, it was
running IE5.0 without problems. I upgraded to IE6 SP1 and ever since,
whenever I access the default ASP web site, it takes ages for the first
page to appear. After that subsequent pages load fine. Code:
View Replies
View Related
I have migrated to Vista Business and installed IIS 7.0. I moved some
classic ASP pages from my old XP box running IIS to the new box. I've
made no changes to the code, which worked fine on the old machine.
They also run fine on a remote server. On the new machine, the ASP
pages are running extremely slow and timing out with the error "cannot
display the web page." I've verified that I'm making connections to my
Access database (which is fine for my low-volume site) and closing the
connections. I've checked the IIS log and seen no issues. I turned off
my firewall briefly, which didn't help. I watched perfmon and didn't
see that unusual amounts of resources were being used. Code:
View Replies
View Related
I have an asp site that of late is having a very very slow response at the production environment and it is taking 6-7 minutes to do the basic operations that are needed. We have come to know that the performance has deterirated after the recent release.
Going through this thread IIS 6.0 slowing down one of the suggestions listed was to make sure one destroys objects the code creates which I have taken care in all the pages. Actually all the new changes that were to be done involved working with session or local variables and so no com objects were touched.
We are using Windows 2000 server with SP4 at all the environments. Could someone tell me some suggestions on how to identify the problem? This is a problem faced by many at the clients end and this occurs even on server restart. Please let me know if there are any additional details that are needed.
View Replies
View Related
I've got a client that has a site that seems to be serving images up slowly.
win2k, xeon, 1gig ram, the box is inhouse. HTML generation and viewing is
blazingly fast. The page size runs around 165k, but is taking 7-10 seconds
to download all the images.
I ran a netstat -an on the box, and see a load of time_wait messages.
The guy who does the networking for them insists that since the images
reside on the same box as the web server, the slowness has nothing to do
with the internal network. hhhmmmm.....
I know there are a hundred reasons for the slowdown, but does the logic of
images on same box not having anything to do with a slowdown make any sense?
View Replies
View Related
I have a basic asp page running that is very slow it has to crunch some info
and when a user hits submit it can take a minute or more for a response. So
what I did was call a second page that should show a gif that is asking them
to be patient.
Unfortunately this never shows (See below). I have tried
other ways as well, but I have been unsuccessful in getting the gif to show.
This has to be simple but I'm not a skilled asp developer so I don;t know
how to do it. Anybody have any ideas?
View Replies
View Related
I just migrated an NT4.0 website (all ASP) to Windows Server 2003 (small business server - deluxe edition) and some pages are very slow to render on client.
Seems to be pages with tables. I can stop the browser by clicking "X" and the table will be partly rendered. The table only has 26 rows and very little content.
Any ideas why this is happening would be appreciated. I have read of others with the same problem but no solutions.
View Replies
View Related
The following code runs in less than one second when used in an ASP page but when used in Session_onStart() in global.asa, the first page in a new session is delayed by more than thirty seconds. The code seems to work - its just slooow. Why is this so and how do I fix it?
Dim cnComDoc
Set cnComDoc = Server.CreateObject("ADODB.Connection")
cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:comdoc.mdb;Persist Security Info=False"
cnComDoc.execute "Insert into SessionInfo
(SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID & "','" &
FormatDateTime(now(), vbGeneralDate) & "','" &
Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
adExecuteNoRecords
Set cnComDoc = Nothing
View Replies
View Related
I am running a query from MS FoxPro and displaying a table after the query is ompleted. I assume the query of the criteria takes longer than displaying the table...but in this case it's reversed.
After the Query is complete, it takes about 10-20 seconds to display the table, which consists of just information from the database. i.e. customer name, number, vehicle make and model, date it was purchased. Those simple items. Is there a way to make it load/display faster? I am using ASP and MS FoxPro.
View Replies
View Related
Anyone know what might cause my ASP to start running slow? It's been running fine until today. Today when I pull a repost, it takes forever to for the code to create the page.
When I go into the Access database itself and run the individual queries, they run just fine. It only takes a fraction of a second for the data to apprear. When I run the ASP code to see it on the webpage,it takes around 30 seconds!
Anyone got any recommandations on what I need to check? It just doesn't make any sense that all the sudden it runs flat out SLOW.
View Replies
View Related
My ASP pages have very slow connections with SQL Server database, although eventually it will reach the page and get the results. The SQL Server database and IIS are in the same machine, I have no idea why it will cause the problem.
I just put this connection string as SSI:
strConnect="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MYDATABASE;Data Source=MYCOMPUTER"
View Replies
View Related
I'm reading an XML file in my ASP script which then uses XSL to format the output. However, the script takes a long time to load the script, almost 30 seconds. Code:
set xml = Server.CreateObject("Msxml2.DOMDocument.4.0")
xml.async = false
xml.load(Server.MapPath("XMLTestfile.xml"))
Does anyone know why the webserver will all of the sudden take so long to load the file when it used to work almost instantly?
View Replies
View Related
where I can find information regarding a problem I am having with w2003 ii6 and asp.net. The first page load each morning can run to 1/2hr, which as you can imagine is not exactly making anyone happy. There doesn't appear to be a newsgroup dedicated to asp.net, though I may have been looking in all the wrong places.. so many groups.
I've found some info on the web related to the problem but nothing which discusses what may be going on, nor how to diagnose it.
View Replies
View Related