Ask a Question related to ASP Database, Design and Development.
-
John Davis #1
slow ASP-SQL database connection
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"
Anyone has any ideas? Please advise. thanks!
John
John Davis Guest
-
rtmpt connection very slow with FP 9,0,115,0
Connecting with rtmpt (http tunneling) to FMS 3 vod service takes 10-15 secs on Flash Player 9,0,115,0. I used Flex Builder 2.01 to compile the... -
Slow non-local connection to fms
Hi, I have the following problem: when connecting to my FMS application from the web - it takes about 2 minutes to make the connection (I see it... -
One NFS connection fine, one NFS connection slow
Ok, this is all a bit odd. I will draw an ascii picture and hope it survives in Google: sun server | .------mandrake... -
Slow connection of XP machines on NT network
I have been hitting my head against the wall on this problem. We purchased new XP Professional machines to connect to our NT network and the... -
'apt-get upgrade' Over Slow Connection
'apt-get upgrade' is fine if you've got a fast Internet connection. However, what do folks do when they still have *slow* Internet connections... -
John Davis #2 slow ASP-SQL database connection
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"
Anyone has any ideas? Please advise. thanks!
John
John Davis Guest
-
Bob Barrows #3 Re: slow ASP-SQL database connection
How are you determining that it's the connection that is slow?
John Davis wrote:> 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"
>
> Anyone has any ideas? Please advise. thanks!
> John
Bob Barrows Guest
-
Bob Barrows #4 Re: slow ASP-SQL database connection
How are you determining that it's the connection that is slow?
John Davis wrote:> 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"
>
> Anyone has any ideas? Please advise. thanks!
> John
Bob Barrows Guest
-
John Davis #5 Re: slow ASP-SQL database connection
I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the current
one.
I wonder if anything to do on IIS or SQL Server settings??
"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:OKDKMOJfDHA.2332@TK2MSFTNGP12.phx.gbl...> How are you determining that it's the connection that is slow?
>
> John Davis wrote:>> > 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"
> >
> > Anyone has any ideas? Please advise. thanks!
> > John
>
John Davis Guest
-
John Davis #6 Re: slow ASP-SQL database connection
I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the current
one.
I wonder if anything to do on IIS or SQL Server settings??
"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:OKDKMOJfDHA.2332@TK2MSFTNGP12.phx.gbl...> How are you determining that it's the connection that is slow?
>
> John Davis wrote:>> > 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"
> >
> > Anyone has any ideas? Please advise. thanks!
> > John
>
John Davis Guest
-
John Davis #7 Re: slow ASP-SQL database connection
I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the current
one.
I wonder if anything to do on IIS or SQL Server settings??
"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:OKDKMOJfDHA.2332@TK2MSFTNGP12.phx.gbl...> How are you determining that it's the connection that is slow?
>
> John Davis wrote:>> > 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"
> >
> > Anyone has any ideas? Please advise. thanks!
> > John
>
John Davis Guest
-
John Davis #8 Re: slow ASP-SQL database connection
I just migrated the database and web pages from one machine to another
machine. The speed of the original web pages are faster than the current
one.
I wonder if anything to do on IIS or SQL Server settings??
"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:OKDKMOJfDHA.2332@TK2MSFTNGP12.phx.gbl...> How are you determining that it's the connection that is slow?
>
> John Davis wrote:>> > 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"
> >
> > Anyone has any ideas? Please advise. thanks!
> > John
>
John Davis Guest
-
Bob Barrows #9 Re: slow ASP-SQL database connection
This question cannot be answered until you verify where the slowdown is
occurring. This will require some debugging to be done with your pages. Use
Response.write's to report on your code timing:
<%
dim t
t= now()
....
response.write datediff("s",t,now()) & "<BR>"
....
response.write datediff("s",t,now()) & "<BR>"
....
Bob Barrows
John Davis wrote:> I just migrated the database and web pages from one machine to another
> machine. The speed of the original web pages are faster than the
> current one.
>
> I wonder if anything to do on IIS or SQL Server settings??
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:OKDKMOJfDHA.2332@TK2MSFTNGP12.phx.gbl...>> How are you determining that it's the connection that is slow?
>>
>> John Davis wrote:>>> 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"
>>>
>>> Anyone has any ideas? Please advise. thanks!
>>> John
Bob Barrows Guest
-
Bob Barrows #10 Re: slow ASP-SQL database connection
This question cannot be answered until you verify where the slowdown is
occurring. This will require some debugging to be done with your pages. Use
Response.write's to report on your code timing:
<%
dim t
t= now()
....
response.write datediff("s",t,now()) & "<BR>"
....
response.write datediff("s",t,now()) & "<BR>"
....
Bob Barrows
John Davis wrote:> I just migrated the database and web pages from one machine to another
> machine. The speed of the original web pages are faster than the
> current one.
>
> I wonder if anything to do on IIS or SQL Server settings??
>
> "Bob Barrows" <reb_01501@yahoo.com> wrote in message
> news:OKDKMOJfDHA.2332@TK2MSFTNGP12.phx.gbl...>> How are you determining that it's the connection that is slow?
>>
>> John Davis wrote:>>> 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"
>>>
>>> Anyone has any ideas? Please advise. thanks!
>>> John
Bob Barrows Guest
-
Bullschmidt #11 Re: slow ASP-SQL database connection
You might want to check that all fields used as criteria or for sorting
are indexed in the database.
Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!
Bullschmidt Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
