OK, the trace is below, as well as the explain from Postgres. I had a closer look at the times and I'm seeing that 20ms is a peak, the trace below is more like the mode, about 3ms, with an average of about 8ms.
Still 3ms for a request which Postgres manages in 0.13ms is still rather large. ---------------------------------------------------------------------------- xcdm01=# explain analyze SELECT t0_t.member_id, t0_t.trader_id, t0_t.exchange_id FROM trader_mapping t0_t WHERE (t0_t.exchange_trader_id = '17664' AND t0_t.exchange_id = 'swx') ; NOTICE: QUERY PLAN: Seq Scan on trader_mapping t0_t (cost=0.00..1.48 rows=1 width=30) (actual time=0.08..0.08 rows=0 loops=1) Total runtime: 0.13 msec ---------------------------------------------------------------------------- [2004-03-26 18:11:41,229] [INFO ] [SequenceRule] Applying rule MapExchangeTraderIdToEquityTraderId to SubscribeInquireResponse[ Order;s=queue/macd/Gateway:Exchange:vtx:TsxReceiver:-;t=queue/macd/Gateway:TrendServer:trdmdmo:2A426BAB812A6D7ACC1D947826B647E8;-----E;144;132617;#0;status(0;;);[ vtx;GB0002634946;GBX;GLOX Test 3.17;B;Wed Mar 24 18:26:25 CET 2004;Wed Mar 24 18:26:25 CET 2004;1;null;true;null;17664;40271;null;169373;null;N;null;Wed Mar 24 00:00:00 CET 2004;C;null;true;0.25;null; ;null;T;D;N;10;null;O;null;null;0;0]] [2004-03-26 18:11:41,229] [TRACE] [org.jboss.ejb.plugins.LogInterceptor] Start method=findByTraderIdAndExchange [2004-03-26 18:11:41,229] [TRACE] [org.jboss.ejb.plugins.TxInterceptorCMT] Current transaction in MI is null [2004-03-26 18:11:41,230] [TRACE] [org.jboss.ejb.plugins.TxInterceptorCMT] TX_NOT_SUPPORTED for findByTraderIdAndExchange [2004-03-26 18:11:41,230] [TRACE] [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came in with tx null [2004-03-26 18:11:41,230] [TRACE] [org.jboss.ejb.plugins.EntityInstancePool] Get instance [EMAIL PROTECTED] com.macd.xConnect.ejbeans.tradermapping.TraderMappingBean [2004-03-26 18:11:41,230] [DEBUG] [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.TraderMapping#findByTraderIdAndExchange] Executing SQL: SELECT t0_t.member_id, t0_t.trader_id, t0_t.exchange_id FROM trader_mapping t0_t WHERE (t0_t.exchange_trader_id = ? AND t0_t.exchange_id = ?) [2004-03-26 18:11:41,231] [TRACE] [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.TraderMapping#findByTraderIdAndExchange] Set parameter: index=1, jdbcType=VARCHAR, value=17664 [2004-03-26 18:11:41,231] [TRACE] [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.TraderMapping#findByTraderIdAndExchange] Set parameter: index=2, jdbcType=VARCHAR, value=vtx [2004-03-26 18:11:41,234] [TRACE] [org.jboss.ejb.plugins.EntityInstancePool] 0/100 Free instance:[EMAIL PROTECTED] com.macd.xConnect.ejbeans.tradermapping.TraderMappingBean [2004-03-26 18:11:41,234] [TRACE] [org.jboss.ejb.plugins.LogInterceptor] End method=findByTraderIdAndExchange <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3827859#3827859";>View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3827859>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
