insert and retrieve huge amount of data

hi,

i am developing a website .i would like to know if it is safe to use servlet+jdbc to insert large data like blob/clob in MYSQL 5.0.i also anticipate large nuber of transactions like dtaa retrival and data storing by users.Is it fin efor me to use MY sql 5.0 and servlets to do this process.please advice me on this.

any help is appreciated.

[363 byte] By [suryakula] at [2007-11-27 11:45:30]
# 1

Depending on the data, it's better to use tools built into the database itself.

Large numbers of users with transactional data just means designing your system well.

If you have to ask, you don't know how. Better to get someone to help you.

Learn Spring:

http://www.springframework.org

It can help with web-based, transactional systems.

%

duffymoa at 2007-7-29 18:02:06 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...