Gunnar Berglund wrote:
>
> Hi all,
>
> we are facing some serious problems with the following case:
>
> we have an application which stores quite a lot of documents to
> database (average document size is 2mb). Application loads document
> template from database and when we are having 100-200 hundred users
> there will be a queue on a weblogic server in order to wait to handle
> those documents and saving the updates to database.
>
> Do you have any ideas how to do this faster or is there something we
> haven't realized.
>
> TIA
> gb
Is "saving to database" really the thing to do in such a case? Can't you
just save pointers to the documents? Also, if I understand you well, in
MSWord-speak people load a .dot and save a .doc; do you really have to
save the formatted document? Couldn't you save something saying 'this is
the model' and 'this is the associated data'? In other words, use a
'style-sheet' logic? The really useful data in a document is often
something relatively small ...
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sat Oct 11 2003 - 13:19:24 CDT
