On Mon, Jul 6, 2009 at 7:41 AM, kokok_kokok<kokok_kokok@...> wrote:

> 1) Create a pool of 8 database connections and create 8 threads to execute
> the SQLs?

Yes. Use classic server. Each connection will run on its own process.
That will use all 8 cpus.
But beware. Each transaction will have its own transaction. If the
database is changed while the starting the connections, you may run
into data consistency issues.

hth,
--
Douglas Tosi
www.sinatica.com