PDFdev is a service provided by PDFzone.com | http://www.pdfzone.com
_____________________________________________________________
Hello, I'm new. Stopping by to ask a question. I'm having a problem that I
ve been unable to solve and am in need of some help.
In brief, I have a recordset object and an execute statement that appear to
be in conflict with each other. When saving a form to the Database (using
FDF, ASP, VBScript ver 5.6, and a Sybase Database), the submit is terribly
slow. If I use two execute statements in the ASP, the submit is quick. If I
comment out the execute and only use the recordset, the submit is quick.
However, I prefer to use the recordset to lock a particular record. The
second can remain an execute, as locking is not needed. Changing both to
use recordsets is also slow. The submit can take up to 3 minutes, which is
unacceptable.
The code I have follows. I have cut out all processes and only left in the
DB connections. This sytax, with everything taken out except the
connections, still slows down the submit. I have also tried putting this in
a flat ASP page, and doing so it only takes 1 second (or less). But whilst
in an ASP relating to a PDF, it can take a great deal of time.
If anyone has insight to this, I would greatly appreciate it. :)
Thanks!
SQL = "select * from FIFORMS"
Set ObjSelct=Server.CreateObject("ADODB.Recordset")
ObjSelct.Open SQL,connectionToDatabase,0,1
ObjSelct.Close
Set ObjSelct = Nothing
sqlstatement="select * from EFORMSUSERS"
Set DfesSelct = connectionToDatabase.Execute(sqlstatement)
DfesSelct.Close
Set DfesSelct = Nothing
PS - changing the SQL does not seem to change the speed, either. I've cut my
select statements down and they query very small tables.
http://www.cynthiablue.net
http://www.animalfoster.com
http://www.utahdogs.com
(aim,y,msn: cynthiabluenet)
To change your subscription:
http://www.pdfzone.com/discussions/lists-pdfdev.html
