RE: Preferred method to access databases from Servlets

Richard,

  I agree with SQL/JDBC is the future infortunatly.
But it is still slow, and will be for the forseable
future. Basically what you are doing when do io
through  an SQL/JDBC a interface is you are taking
java , which is already interpreted, creating a
statment and running that statement trough the driver,
with th driver interpreting and executing the
statement, I cannot  see how this double
interpretation will ever be as fast as any type of
record level access. No don't get me wrong if the
speeds ever gets even close we will probably move over
to the SQL/JDBC area just becuase the support and
documentation is better if nothing else. 

I will check out the caching though, if it gives the
performance increase you seem to think it will, then
it may be worth while to look into it.


Thanks 
Eric


=====
Eric Merritt
Information Systems Consultant
McCormack & Associates, Inc.
Rock Hill, South Carolina
(V) 803-327-3358 X 225
eric@mccinc.com
http://www.mccinc.com/

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---