Hi all, The task that I am working on involves export large amounts of the data into the SAP DB database. As a consequence I am interesting in optimizing the performance of the I/O operations. As I found out the SAP DB threading model presumes a combination of the native threads and coroutines. Datawriter task is implemented as a coroutine. Is the actual physical writing to the disk made by the datawriter task or it spawns the native threads? In the first case it means that while synchronous I/O operation is performed all other activities are stopped. Is there any settings besides _USE_THRD_FOR_TSK (which I don't want to alter as dispatching of the coroutines generally much faster than pthreads) that controls the threading model behaviour? Is the parameter _USE_IOPROCS_ONLY ensures that all the I/O operations performed asynchronously if it sets to true?
Thanks in advance. Dmitri _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
