REPOST: Best values for parallel_min_servers/parallel_max_servers

What is the best value for my configuration :

4 CPU, lot of Ram
and a Batch program.

I can run multiple instance (4 max) of this programme on different part of the data, in our old configuration max/min was set to 0, and we paralelize this programme explicitely in running multiple instance on different data (intance 1 on the first 1/4 of the data,... instance 4 on the last 1/4 of the data). Each instance can Select/Update/Delete on the same table (but on different data).

What is the best ? put some values into min/max server ? Set min/max to 0 and running multiple instance ? Or mixing the 2 method ?

Thanks for any help

Ludo

• WAS CANCELLED BY =======: From: "Jaret Lafoudravecmonhné" <toto_at_toto.com> Control: cancel <a2r7r5$ho7$1_at_reader1.imaginet.fr> Subject: cmsg cancel <a2r7r5$ho7$1_at_reader1.imaginet.fr> Date: Mon, 28 Jan 2002 02:18:32 GMT Message-ID: <cancel.a2r7r5$ho7$1_at_reader1.imaginet.fr> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.ruhr-uni-bochum.de!news-koe1.dfn.de!RRZ.Uni-Koeln.DE!blackbush.xlink.net!blackbush.de.kpnqwest.net!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40716304

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 03:22:34 CST