Sorry, the affinity setting was about SS, not SC. Wrong copy/paste ;-) []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br
IA>> When you have a single user (filling the info in the database) you don`t IA>> feel the difference because it is basically the same CPU core doing the IA>> work. CHC> Here is more information (from my logs and memory): CHC> The LOAD was set to simulate 10 users inserting information at the same CHC> time so, there was 10 connections and 10 threads acting at the same CHC> time to fill up the DB. CHC> Some weird results also appeared when comparing FB 3 TPC-C results in CHC> the notebook. FB 3 performance was 50% worse compared to FB 2.5 CHC> SS/CS/SC. From my logs: CHC> 2.5.1 CS - TPC-C Throughput: 1390.19 tpmC CHC> 2.5.1 SC - TPC-C Throughput: 1221.92 tpmC <- Affinity set to 1 CHC> 2.5.1 SS - TPC-C Throughput: 1306.06 tpmC CHC> 2.5.2 CS - TPC-C Throughput: 1144.95 tpmC CHC> 2.5.2 SC - TPC-C Throughput: 1156.87 tpmC <- Affinity set to 1 CHC> 2.5.2 SS - TPC-C Throughput: 1358.34 tpmC CHC> 3.0 SS - TPC-C Throughput: 514.43 tpmC (SharedCache was true and SharesDatabase was false) ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel