HP3000-L Archives

December 2003, Week 2

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
OT: VB .NET ASPX runs slow
From:
KENT WALLACE <[log in to unmask]>
Reply To:
KENT WALLACE <[log in to unmask]>
Date:
Fri, 12 Dec 2003 15:21:57 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (16 lines) 
If I open a SQL 2000 database in my ASPX VB code.  Then I do 300 reads
by key(SELECTS).  I get really bad performance on a fast server.

We theorize that every "SELECT" is logging on and off the SQL 2000
database.

Is this true? Do I need to use ADO to get around this problem instead
of reading?

Thanks
Kent Wallace
Boise Id

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2