|
 |
asp_databases thread: Database access speed problems
Message #1 by "Rick Brose" <brose@u...> on Tue, 24 Apr 2001 18:53:38
|
|
I am developing a web based tool for the company I work at and have been
testing it in IE5. Well, since it needs to work in Netscape too I decided
to give it a runthorugh today using Netscape. Everything worked fine and I
fixed the few formatting problems but one thing is stumping me. Whenever I
try something that involves accessing the database using Netscape it takes
5 to 30 times (rough estimate) longer to execute. Is there a reason that
Netscape takes longer? Is there some additional code I need added in for
Netscape to run it at peak speed? I am testing with Netscape 4.7 and need
it to be compatible with it so upgrading is not an option. Thanks for your
help.
Message #2 by "Tomm Matthis" <matthis@b...> on Tue, 24 Apr 2001 15:18:50 -0400
|
|
Are you rending your data to a table? And thereby benchmarking against
when the table appears?
If so, then in table tag, set the ROWS=3D to the rs.recordcount
property. This will let Netscape know ahead of time how many rows to
expect... IE seems to be more forgiving about it than NS ....
Hope that helps.
Tomm
> -----Original Message-----
> From: Rick Brose [mailto:brose@u...]
> Sent: Tuesday, April 24, 2001 6:54 PM
> To: ASP Databases
> Subject: [asp_databases] Database access speed problems
>
>
> I am developing a web based tool for the company I work at and have
been
> testing it in IE5. Well, since it needs to work in Netscape too I
decided
> to give it a runthorugh today using Netscape. Everything worked
> fine and I
> fixed the few formatting problems but one thing is stumping me.
> Whenever I
> try something that involves accessing the database using Netscape
> it takes
> 5 to 30 times (rough estimate) longer to execute. Is there a reason
that
> Netscape takes longer? Is there some additional code I need added in
for
> Netscape to run it at peak speed? I am testing with Netscape 4.7 and
need
> it to be compatible with it so upgrading is not an option. Thanks
> for your
> help.
Message #3 by Gregory_Griffiths@c... on Wed, 25 Apr 2001 11:34:56 +0100
|
|
Are you running Netscape on the same machine as the webserver ? It is a
known issue that Netscape has a problem in this configuration, the fix
seems to be to lower the priority of the Netscape.exe process in
Windows.
> -----Original Message-----
> From: brose@u... [mailto:brose@u...]
> Sent: 24 April 2001 18:54
> To: brose@u...; asp_databases@p...
> Subject: [asp_databases] Database access speed problems
>
>
> I am developing a web based tool for the company I work at
> and have been
> testing it in IE5. Well, since it needs to work in Netscape
> too I decided
> to give it a runthorugh today using Netscape. Everything
> worked fine and I
> fixed the few formatting problems but one thing is stumping
> me. Whenever I
> try something that involves accessing the database using
> Netscape it takes
> 5 to 30 times (rough estimate) longer to execute. Is there a
> reason that
> Netscape takes longer? Is there some additional code I need
> added in for
> Netscape to run it at peak speed? I am testing with Netscape
> 4.7 and need
> it to be compatible with it so upgrading is not an option.
> Thanks for your
> help.
>
Message #4 by "Dallas Martin" <dmartin@z...> on Wed, 25 Apr 2001 08:00:23 -0400
|
|
Since Netscape runs on the client, are you saying that every Netscape client
must have the Netscape priority lowered? Because, I have experienced
slower performance using Netscape vs IE from client machines.
Thanks,
Dallas
----- Original Message -----
From: <Gregory_Griffiths@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, April 25, 2001 6:34 AM
Subject: [asp_databases] RE: Database access speed problems
> Are you running Netscape on the same machine as the webserver ? It is a
> known issue that Netscape has a problem in this configuration, the fix
> seems to be to lower the priority of the Netscape.exe process in
> Windows.
>
> > -----Original Message-----
> > From: brose@u... [mailto:brose@u...]
> > Sent: 24 April 2001 18:54
> > To: brose@u...; asp_databases@p...
> > Subject: [asp_databases] Database access speed problems
> >
> >
> > I am developing a web based tool for the company I work at
> > and have been
> > testing it in IE5. Well, since it needs to work in Netscape
> > too I decided
> > to give it a runthorugh today using Netscape. Everything
> > worked fine and I
> > fixed the few formatting problems but one thing is stumping
> > me. Whenever I
> > try something that involves accessing the database using
> > Netscape it takes
> > 5 to 30 times (rough estimate) longer to execute. Is there a
> > reason that
> > Netscape takes longer? Is there some additional code I need
> > added in for
> > Netscape to run it at peak speed? I am testing with Netscape
> > 4.7 and need
> > it to be compatible with it so upgrading is not an option.
> > Thanks for your
> > help.
> >
>
Message #5 by Gregory_Griffiths@c... on Wed, 25 Apr 2001 13:30:10 +0100
|
|
I was referring specifically to that of a Netscape browser running on
the same machine as the webserver. However, Netscape's HTML rendering
engine may process the HTML you send it slightly differently from IE
and some tags or collections of tags - e.g. nested tables - may be
slower in Netscape.
> -----Original Message-----
> From: dmartin@z... [mailto:dmartin@z...]
> Sent: 25 April 2001 13:00
> To: asp_databases@p...
> Cc: dmartin@z...
> Subject: [asp_databases] RE: Database access speed problems
>
>
> Since Netscape runs on the client, are you saying that every
> Netscape client
> must have the Netscape priority lowered? Because, I have experienced
> slower performance using Netscape vs IE from client machines.
>
> Thanks,
> Dallas
>
>
>
>
> ----- Original Message -----
> From: <Gregory_Griffiths@c...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, April 25, 2001 6:34 AM
> Subject: [asp_databases] RE: Database access speed problems
>
>
> > Are you running Netscape on the same machine as the
> webserver ? It is a
> > known issue that Netscape has a problem in this
> configuration, the fix
> > seems to be to lower the priority of the Netscape.exe process in
> > Windows.
> >
> > > -----Original Message-----
> > > From: brose@u... [mailto:brose@u...]
> > > Sent: 24 April 2001 18:54
> > > To: brose@u...; asp_databases@p...
> > > Subject: [asp_databases] Database access speed problems
> > >
> > >
> > > I am developing a web based tool for the company I work at
> > > and have been
> > > testing it in IE5. Well, since it needs to work in Netscape
> > > too I decided
> > > to give it a runthorugh today using Netscape. Everything
> > > worked fine and I
> > > fixed the few formatting problems but one thing is stumping
> > > me. Whenever I
> > > try something that involves accessing the database using
> > > Netscape it takes
> > > 5 to 30 times (rough estimate) longer to execute. Is there a
> > > reason that
> > > Netscape takes longer? Is there some additional code I need
> > > added in for
> > > Netscape to run it at peak speed? I am testing with Netscape
> > > 4.7 and need
> > > it to be compatible with it so upgrading is not an option.
> > > Thanks for your
> > > help.
> > >
>
Message #6 by Burc Kaya <bkaya@f...> on Wed, 25 Apr 2001 09:27:50 -0500
|
|
From where can you lower Netscape prority in the client mahine?
Dallas Martin wrote:
> Since Netscape runs on the client, are you saying that every Netscape client
> must have the Netscape priority lowered? Because, I have experienced
> slower performance using Netscape vs IE from client machines.
>
> Thanks,
> Dallas
>
> ----- Original Message -----
> From: <Gregory_Griffiths@c...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, April 25, 2001 6:34 AM
> Subject: [asp_databases] RE: Database access speed problems
>
> > Are you running Netscape on the same machine as the webserver ? It is a
> > known issue that Netscape has a problem in this configuration, the fix
> > seems to be to lower the priority of the Netscape.exe process in
> > Windows.
> >
> > > -----Original Message-----
> > > From: brose@u... [mailto:brose@u...]
> > > Sent: 24 April 2001 18:54
> > > To: brose@u...; asp_databases@p...
> > > Subject: [asp_databases] Database access speed problems
> > >
> > >
> > > I am developing a web based tool for the company I work at
> > > and have been
> > > testing it in IE5. Well, since it needs to work in Netscape
> > > too I decided
> > > to give it a runthorugh today using Netscape. Everything
> > > worked fine and I
> > > fixed the few formatting problems but one thing is stumping
> > > me. Whenever I
> > > try something that involves accessing the database using
> > > Netscape it takes
> > > 5 to 30 times (rough estimate) longer to execute. Is there a
> > > reason that
> > > Netscape takes longer? Is there some additional code I need
> > > added in for
> > > Netscape to run it at peak speed? I am testing with Netscape
> > > 4.7 and need
> > > it to be compatible with it so upgrading is not an option.
> > > Thanks for your
> > > help.
> > >
>
Message #7 by "Rick Brose" <brose@u...> on Wed, 25 Apr 2001 17:38:42
|
|
> Are you running Netscape on the same machine as the webserver ? It is a
> known issue that Netscape has a problem in this configuration, the fix
> seems to be to lower the priority of the Netscape.exe process in
> Windows.
This is what I was doing. I tested the pages using my bosses computer and
it runs much faster. I didn't know this was a known issue. Thank you very
much.
|
|
|
View Cart
