Session Storage Vs. Frequent DB Calls

I'm developing web surveys where users logon to a web survey and answer up
to about 50 questions, one after the other, shown only one question at a
time. The answers are saved in a database.

A fellow developer and I are discussing when is the best time to save the
answers. We have two approaches in mind:

Approach 1:
After each question is answered, the answer is saved in the database.
Sessions are only used to store the User ID.

Approach 2:
After each question is answered, the answer is saved in a session variable.
When the user has finished the entire survey, all the answers are saved at
once in the database. Also, if the user logs out, or if the session times
out, the answers answered so far are all saved in the database at once.

The amount of actual data sent to the database is the same in both
approaches, but Approach 1 have much more frequent calls to the DB, thus
creating an overhead of opening and closing connections. I'm not sure how
significant that is. On the oter hand, Approach 2 store a lot of data in
sessions. I'm not sure how bad a thing that is.

Which approach is better and for what reasons? I'd be happy to supply more
information if needed.

View Replies


ADVERTISEMENT

Not Enough Storage

We have a site running on w2k, IIS5.0. The problem is that the site intermittently stops working and returns the error "Not enough storage is available to complete this
operation.". This is only for ASP pages. HTML pages are served fine. Restarting the services gets the site working for a few minutes.

There is no problem with space on any drives.The size of the paging file seems fine.
The registry size is fine.I have tried everything I can think of. It is not page
specific. Even just renaming a plain html file to a .ASP extension causes the error.

View Replies View Related

Storage Issue

I want to have a variable in wich I will store a date.
this variable should be stored in a DataBase, because I want it to be in all my website pages and I don't want it to be erased after the web host starts over (that marks out application variables).
The real problem here isn't were to store it, cause that's gotta be in a DB (I think), but how to store it.
I don't want to make a whole table with one feild in it only for one row, thats total waste of place on my host.

View Replies View Related

'could Not Open Macro Storage'

I'm copying an office automation script from NT4 to w2k, and have as far is
can be certain replicated all the settings correct, but at the point where
the word.application object tries to create a new document using a specific
template, I get either this error or one about incorrect file paths.

I've been through dcomconfig, and have tried both interactive and launching
user as the identity for word, but even with all the correct settings from
the kb articles, and setting modify rights to temp and winnt/temp, cannot
get beyond these errors.

This script works fine via the NT4 box its moving off, and the only
difference of any value with the w2k box is that integrated authentication
is being used on the new box.

View Replies View Related

Open Macro Storage

I am using vb dll in my asp page. In that dll i am creating word documents (its like a mail merge sort of application). But when i call the dll in my asp page it gives me the below error.

Microsoft Word (0x800A175D)
Could not open macro storage.
/welcome/generatedoc.asp, line 57

Code:

a = welcome.GenerateWelcomeLetter (cstr(qry),cstr(template_filename), cstr(save_filename))

View Replies View Related

Storing Images In SQL Server Storage And Retrieve

1) I need to build an admin page that allows me to browse to the file that I
want stored in SQL Server 2000 in an image field, have it uploaded to the
server, and then stored in the db. I see this done all the time, so I don't
think this part is too hard, but I'm not sure how to get the image into the
db.

2) I want to display the image within a web page, so I would want to pull
the image out of the db, place it on my web server in a certain location,
and then reference the file in the HTML. How do I do that?

View Replies View Related

Recursive Calls

I have implemented a logic for my requirement with a recursive call. The logic is I need to get IDs from database for a scenario. There are corresponding records for each ID.

I need to store these IDs in an array variable. Then I need to get (dependent)IDs for the fields in each ID. There may be morethan one dependent per each ID. I append these IDs to my array. Like this it goes.

The problem is if there are many levels like this, the number of database cursor count is reaching to maximum and I'm getting the error

{Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded }

each recursive call runs a SELECT query.

Can any one suggest me an alternate solution for this ?

View Replies View Related

Function Calls

I'm terribly sorry if this has been asked before, but I need a clear explenation without having to sift through other bits of information.

Can somone explain how functions work in asp (not asp.net)? I need to call a function that returns a value, and I get an error when I have a return statement in there. If there is no "return" statement, then what do you use to get this value back?

View Replies View Related

ASP Server Calls

I am using WindowsXP and a book to try to learn ASP.

The book instructed me to install IIS & .Net Framework v1.1 (which I did)

In the book they gave me the following code:

View Replies View Related

Optimizing Asp Database Calls

I'm very interested in finding out what ways you experts out there have made your data dips more efficient in your asp (not asp.net) code.

I have a wizard-type application that dips into the database with each page, I know there's a better way to do this out there, just pressed for time and can't think right now.

View Replies View Related

How To Use IIS To Redirect Http Calls?

I need to implement an application that receives http calls from a remote
client, do something with it and returns some feedback. I want to use IIS
(version 6) as my front end http server (with https and ssl services) which
will facilitate all the requirements of a http server and then foreword the
incoming call to my application and will return the process result to the
client at the end.

Does IIS support this? And if yes - what are the requirement from my application to use it (built in .net if anyone interested)?

View Replies View Related

Database Calls Made

Is there a way I can see how many database calls were made from my script to the db server to check how well my SQL queries are formed?

I get the time taken to execute the queries, but in that time taken, I want to know how many calls were made to the DB server. Is it possible?

View Replies View Related

Database - Recursive Function Calls

..:: The Specs:

MS Access 2000 (host charges extra for SQL/MySQL)
MS Windows Server 2003 (prod) / MS XP SP1 (dev)

..:: The setup:

The database has been setup with two tables;

tblDownloads
tblCatagories

Each "download" consists of a catagory field that corresponds to fldID in
tblCatagories. Each catagory, where the catagory is a parent, has a parent
field of value: 0 and each child, has a field with a value corresponding to
the fldID of it's parent. Code:

View Replies View Related

Correlate ASP Page With Timings Of Its DB Calls

I am looking for a tool/product (commerical or shareware) to correlate
classic ASP pages (not ASP.NET) with timings of ADO calls made from
each ASP page. The information I am looking for are

T1, url = http://..../product.asp,
DB Server=SQLSvr1, DB Name=products
ADODB.Connection.Open 10ms
ADODB.Recordset.Open 189ms
...

T2, url = http://.../search.asp,
DB Server=SQLSvr2, DB Name=productindex
ADODB.Connection.Open 15ms
ADODB.Connection.Execute 350ms
...

It would be nice if the tool can automatically rewrite existing ASP
pages if necessary.

This would be a good performance monitoring tool for classic ASP
pages.

View Replies View Related

Cursor Count Problem In Recursive Calls

I'm using the following function, which uses a recursive call. every time when I get a conf it opens a record set. So increases the cusor count. Some times I'm getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded.

How can I avoid this ? Code:

View Replies View Related

Database Calls, Server Transfers, Sessions, And Cookies

Any body know of a resource that compares/benchmarks the expense (in terms of milli seconds, or server load) of using various programing options?

I know a lot of articles and forum posts reccomend best practices between functions and programming options, but I would be interested in some type of definitive benchmark to decide between various prgramming options, depending on the need.

For example, I can call a Recordset and quickly write it into an array, so that the connection can be closed even before I write the data to the HTML page. This would save conection time and server resources, but I'd like to be able to judge the worth when considering coding it.

Every time I do a Server.Transfer how expensive is it to the server? How much am I loading the server with Session varaibles? If I store some info in a cookie, but have to call it, how long will that take? Am I using up server resources by creating large arrays?

View Replies View Related

Multiple Calls With Inet Object Causes Site To Lock Up

I developed a website that posts data to another url via the Inet object.

I should mention that the posting code is wrapped in a VB 6 dll, and that
dll is called from ASP. Code:

View Replies View Related

How To Find The Session Expired Or Not Without Using Any Session Varaibles

how to find the session expired or not without using any session varaibles?

View Replies View Related

Accessing ASP Session From ASP.NET Via Session Cookie

I have a site that I'm trying to migrate to ASP.NET from ASP, and the
foremost stumbling block I'm hitting is session state between the ASP
and ASP.NET applications. In order to access this information, I'm
doing a HttpWebRequest from the ASP.NET side into an .asp page,
passing the session name on the get in order to request it from the
ASP side and write it back to the response stream, giving ASP.NET
access to it. Of course I change sessions each time I make the call
from the ASP.NET side.

Soooooo, I'm thinking to myself, "Self, shouldn't you be able to fake
out the server by getting the session cookie from the initial usage of
the asp, pass that data to the ASP.NET, and use that to send a request
back the ASP side under the appropriate session?"

From a real high level, I enter the site via a .asp page. This page
in turn calls .aspx page from within a frame ......

View Replies View Related

Tracking Session Variables From Outside The Session

I want to create an administration page which lists all the current users who are on the site at the moment.

I know coldfusion has this feature built in using the SessionTracker class... does ASP have something similar? If not... is there any way I can just iterate through all the session files on the server...?

View Replies View Related

Session.session Not Maintained

I have a site developed using ASP, but each page I enter has a different session id when accessing the site using the domain name of the site. When accessing the site from my network and using the internal IP address, it is OK. Any ideas?

View Replies View Related

Comparison Between "session.abandon" & "Session.Contents.Remove"

I want the suggestion what is better for use between:

Session.abandon
&
Session.Contents.Remove

View Replies View Related

Session Var.

I wrote a website, which uses the session to store and track some vars.

Now I am gonna to covert it to desktop application by Activesite compiler 5, however, it doesnot support session , cookie , application() . SO ,I have no idea to find something can instead of session.

My orignal processing: Session -> modify Session var -> store to Database.

View Replies View Related

About ASP Session ID

There is a problem about ASP session ID. ASP session is implemented by storing session id in a session cookie, but I read this cookie in ISAPI Filter, get a string as following:
ASPSESSIONIDQADCQQTS = IAOFCBBCGDGMDGCNJIKPNBAN

But the real session ID is 554851848. (Real sessionID is sessionID property the ASP session object)

Problem is what is relation between them? And how to get real session ID from cookie session ID.

View Replies View Related

Session

I did a session("adminlogin")=1, if I post it to the same page, it returns true. But if I response.redirect to another page. This value doesn't exist anymore. This is on the actual server where all the ms security is updated.

The same script worked okay on my test server (the security patch not patched yet.)

Has anyone encountered this? How do you overcome it?

I tried searching the net it says the problem lies with a ms security patch. How I wish I can unintall that patch.

View Replies View Related

Session ?

when does a sesson object expire?

- at the end of 20 minutes
- after they close their browser ? does that end the session?

View Replies View Related

How To Get New Session

I have a home page in html with two buttons to call my main.asp in another window my problem is:

1-From my home page I open another web page my main menu, this new page have a SessionID. (OK)

2-If I open another web page from the same home page, this new page have the same SessionID as the page open in first step

I want to get a new SessionID for every page I open from my home page and don't want to abandon the first session...

View Replies View Related

IIS Session And IE7

I have asp and asp.net web application. When I run it in IE7 in first tab it
starts a new session. When I open second tab and browse to the same site the
new session is not started (infact I need to have new session there).

Whereas, 2 IE instances generate 2 unique sessions. Only issue is with IE
tabs. Firefox also has similar things but lets not talk about firefox here.
I am more concerned with IE only.

View Replies View Related

Session

In my login script I set session("User") = rs("User") the session timeout is set to 20 min

Do I need to setup some kind of update session variable on each page so that the timeout does run out or does iis update the variable aslong as I'm browsing the website ?

And another thing, <% application("something") %> works fine on my test server but once I implement it onto the main webserver I dont get any text out, is there some kind of switch that enables this function ?

View Replies View Related

Session Is Nothing

How can I know if a user session had timed out ?
I always get an error in my asp page when I try to access
my session variable if it timed out.

View Replies View Related

Using Session

My buttons default as you can see in the code. But I now want to take what is already choosen in database and chose apropriate button. Can I use a session to choose a radio button?
Code:


<TD><b><font face="Arial" color="#000080">Password</TD>
<TD><input type ="text" value="<%=Password %>" input name="Password" size="50" ><input type ="Hidden" value="<%=userNumber %>" input name="userNumber" size="50" ></TD>
</TR>
<TR>
<TD><b><font face="Arial" color="#000080">Billing Choice</font></b></TD>
<TD><fieldset style="padding: 2">
<input type="radio" value="Monthly" checked name="R1">Monthly
<input type="radio" name="R1" value="Quarterly">Quarterly
<input type="radio" name="R1" value="Annually">Annually</fieldset><p>Hold
Billing Date <input type="text" name="NextBillDate" size="20" Value=<%=NextBillDate%>></TD>
</TR>

View Replies View Related

Session Var

I am using the session(loggedin) to see if a user is logged into that section of the site. The problem is that it is timing out on them, is there a way to define the length of the session (I think it times out at 10 or 20 mins currently), but to extend it to an hour or so. Any thoughts.

View Replies View Related

Session

I've developed a shopping cart app in ASP, to secure transaction by SSL, it 've put only the checkout page in SSL but all other pages i.e. product, cart etc remains on non SSL connection. How can I track user session from non SSL to SSL checkout page as the SessionID changes when shifting to SSL (to prevent session stealing/ hijacking). I'm tracking user session by putting SessionID in cart DB with products. Given below the preview of cart table ....

View Replies View Related







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