Re: How to configure/tune Oracle 8.1.6 for a web application?

Tell us about your cursors and how you're connecting to the database and querying - e.g stored procedures etc.

What does a typical query look like ? what is being executed 40 times /second ?

how are the two machines connected ? how many network segments apart are they ?

what protocol do you use to get the data from the database server ?

and so on ... more data needed, including why you think the database is slow.
"Niklas" <niklas.hultberg_at_adera.se> wrote in message news:920bdf02.0301020222.22691523_at_posting.google.com...
> Hi!
>
> I have an Oracle 8.1.6 running on a Windown NT4 as a db source and a
> Windows 2000 machine as a webserver. I have developed a web site where
> each page is connecting to the database ca 10 to 40 times. When
> testing the site I can see that the webserver is waiting for the db
> quite a lot. I am not sure that the db is configured optimally
> (everything is default) for handling multiple queries at once. That
> is, the same user (internetuser) is querying the database up to 40
> times within seconds. What can I do to speed up the querying process?
> I have realized that MTS is something I should use (or shouldn't I?),
> but how do I configure that?
>
> I would be very happy with any kind of advice regarding this matter!
>
> Yours,
> Niklas Hultberg
Received on Thu Jan 02 2003 - 05:26:49 CST