----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Andy,
>My data volumes are medium sized, ~1Gb but
>my JVM crashed very early so I assumed the
>data size wasn't an issue.
I did say small :) queries rarely pull over the 100Kb mark, 90% are sub 1Kb.
The database size itself wont grow larger than 100Mb.
>What SP are you using with NT 4?
SP4
>Have your tried your s/w on a multi-processor box?
No it just didnt need that sort of horsepower.
>Were you using RMI in your servlets?
No it didnt require that sort of utility.
>I did download and install the latest Microsoft Data Access upgrade
It is all running on year old stuff now. Once it sat as stable the OS has
been left alone maintenance wise.
>I think the key problem here is determining "right environment and
>conditions" isn't it?
For sure. The system runs as standalone on a PIII500, Apache/JServ runs at
about 2% - 9%, the JVM at 64Mb. The system is so under-taxed it isnt funny.
Yet the website/servlet/database serves approx 50 dynamic pages.
>Concurrency wasn't an issue with my s/w since it
>crashed the JVM with only one connection to the database.
Have you been using a connection pool to connect to the database rather than
making a new connection each time from your code? It takes the wear and tear
out of continually creating new connections plus gives huge "user apparent"
performance boosts.
I use an Administrative class which loads on the webserver start up with the
JServ zone [servlet.startup], the connection pool loads and initializes from
that class. If the connections crap out they do it at startup that way and
not when data is being asked for.
I have also found Win NT to be picky with JVM's too, especially the JRE
JVM's.
Cameron Riley
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
