Hello Chuck, Single query runs at single thread (plus I/O in separate thread). Without waiting for disk, it's faster to run it in a single thread than to parallelize and get synchronization overheads (and bug-prone complications). With waiting for disk, CPU times does not matter -- idle CPU waits for disk reads.
The key requirement to an RDBMS database is an ability to serve hundreds clients in parallel. Having 8 or more queries from 8 or more clients, all cores of the box will have something to run. When we complete cluster version you will be able to parallelize a query between boxes, in that case many boxes may simultaneously run many threads per query; but any given box of the cluster will run no more than one thread per query at time. The cluster wins in speed because total RAM is bigger, not because multi-threading per query is so useful. Best Regards, Ivan Mikhailov, OpenLink Software. On Sun, 2008-05-11 at 18:28 -0700, Chuck Borromeo wrote: > Hi Hugh, > Thanks for the information about the new drivers. I have a tuning > question. Right now, we have a dual CPU, 8 core Power Mac server running > Leopard. We have our Virtuoso server striped across 2 separate disks (to > reduce I/O contention). When we execute a query, only one of the 8 cores is > active at any given time. Is there any way to have the queries run across > multiple cores? Are there any other tuning tips? Specifically, we would > like to improve our CPU utilization. > Thanks, > Chuck > > > > ____________________________________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
