Have you tried connecting using psql?
What happens when you run the same queries?

How do you connect to the database? Maybe
your networking is stuffed ... is it on
the same box? Try pinging ...

We use postgres against jboss (standalone, no tomcat)
and Linux 2.4 and it works like a dream (we did some 
very superficial speed comparison against oracle and 
the performance for our type of app was about the same)
and we have tables up to 500,000 rows ... the queries
we have are not particularly complex though.

The select you describe should be around 10-20ms
or so ...

R.

-----Original Message-----
From: G.L. Grobe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 11:31 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] dbase is acting way too slow


Well, seems I've finally got the database configured correctly, at least it
starts w/o any errors. But I'm still getting my same original behavior. The
problem I started to try and fix.

My dbase queries are extremely slow, but they work. I'm doing a query
through *7* records in a table w/ only 5 fields and it literally takes 10-20
seconds for each query (that's 10-20 seconds for a 'select * from mytable').
I get the result sets back ok, but as I print out each query, just takes
waay too long.

As usual, thnxs for all the help.

--- jboss output -------------------------------
cassia(build):/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/bin$
./run_with_tomcat.sh
JBOSS_CLASSPATH=:/u/public/jdk1.3/lib/tools.jar:run.jar:../lib/crimson.jar
jboss.home = /u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss
Using JAAS LoginConfig:
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/conf/tomcat/auth.conf
Using configuration "tomcat"
[root] Started Log4jService,
config=file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/conf/tomcat/log4j.prope
rties
[Info] Java version: 1.3.0,Sun Microsystems Inc.
[Info] Java VM: Java HotSpot(TM) Server VM 1.3.0,Sun Microsystems Inc.
[Info] System: Linux 2.4.4,i386
[Shutdown] Shutdown hook added
[Service Control] Initializing 27 MBeans
[WebService] Initializing
[WebService] Initialized
[NamingService] Initializing
[NamingService] Initialized
[JNDIView] Initializing
[JNDIView] Initialized
[TransactionManagerService] Initializing
[TransactionManagerService] Initialized
[ClientUserTransactionService] Initializing
[ClientUserTransactionService] Initialized
[JaasSecurityManagerService] Initializing
[JaasSecurityManagerService] Initialized
[JdbcProvider] Initializing
[JdbcProvider] Loaded JDBC-driver:org.postgresql.Driver
[JdbcProvider] Initialized
[XADataSourceLoader] Initializing
[XADataSourceLoader] Initialized
[XADataSourceLoader] Initializing
[XADataSourceLoader] Initialized
[ServerDataCollector] Initializing
[ServerDataCollector] Initialized
[ContainerFactory] Initializing
[ContainerFactory] Initialized
[EmbeddedTomcatServiceSX] Initializing
[EmbeddedTomcatServiceSX] Initialized
[JBossMQService] Initializing
[JBossMQService] Initialized
[JMSProviderLoader] Initializing
[Default] queue factory name: XAQueueConnectionFactory
[Default] topic factory name: XATopicConnectionFactory
[JMSProviderLoader] Initialized
[ServerSessionPoolLoader] Initializing
[ServerSessionPoolLoader] Initialized
[J2eeDeployer] Initializing
[J2eeDeployer] Initialized
[RARDeployer] Initializing
[RARDeployer] Initialized
[ConnectionManagerFactoryLoader] Initializing
[ConnectionManagerFactoryLoader] Initialized
[ConnectionManagerFactoryLoader] Initializing
[ConnectionManagerFactoryLoader] Initialized
[ConnectionManagerFactoryLoader] Initializing
[ConnectionManagerFactoryLoader] Initialized
[ConnectionFactoryLoader] Initializing
[ConnectionFactoryLoader] Initialized
[ConnectionFactoryLoader] Initializing
[ConnectionFactoryLoader] Initialized
[AutoDeployer] Initializing
[AutoDeployer] Initialized
[JMXAdaptorService] Initializing
[JMXAdaptorService] Initialized
[RMIConnectorService] Initializing
[RMIConnectorService] Initialized
[MailService] Initializing
[MailService] Initialized
[Service Control] Initialized 27 services
[Service Control] Starting 27 MBeans
[WebService] Starting
[Default] Started on port 8083
[Webserver] Codebase set to http://cassia:8083/
[Webserver] Started webserver on port 8083
[WebService] Started
[NamingService] Starting
[NamingService] Starting jnp server
[NamingService] Started jnpPort=1099, rmiPort=0, Client SocketFactory=null,
Server SocketFactory=null
[NamingService] InitialContext Environment:
[NamingService] key=java.naming.factory.initial,
value=org.jnp.interfaces.NamingContextFactory
[NamingService] key=java.naming.factory.url.pkgs,
value=org.jboss.naming:org.jnp.interfaces:org.jboss.naming:org.jnp.interface
s
[NamingService] Naming started on port 1099
[NamingService] Started
[JNDIView] Starting
[JNDIView] Started
[TransactionManagerService] Starting
[TransactionManagerService] Started
[ClientUserTransactionService] Starting
[ClientUserTransactionService] Started
[JaasSecurityManagerService] Starting
[Default] JAAS.startService, cachePolicy=null
[Default] JAAS.startService,
SecurityProxyFactory=org.jboss.security.SubjectSecurityProxyFactory@687719
[JaasSecurityManagerService] Started
[JdbcProvider] Starting
[JdbcProvider] Started
[XADataSourceLoader] Starting
[DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
[XADataSourceLoader] Started
[XADataSourceLoader] Starting
[PostgresqlDB] XA Connection pool PostgresqlDB bound to java:/PostgresqlDB
[XADataSourceLoader] Started
[ServerDataCollector] Starting
[ServerDataCollector] JBoss Management Service 'servercollector' bound to
servercollector
[ServerDataCollector] Started
[ContainerFactory] Starting
[ContainerFactory] Started
[EmbeddedTomcatServiceSX] Starting
[EmbeddedTomcatSX] Starting EmbeddedTomcatSX....
[Default] Starting tomcat. Check logs/tomcat.log for error messages
[EmbeddedTomcatSX] OK
[EmbeddedTomcatServiceSX] Started
[JBossMQService] Starting
[Default] Server Version 0.8 Started
[JBossMQService] Started
[JMSProviderLoader] Starting
[JMSProviderLoader] JMS provider Adapter DefaultJMSProvider bound to
java:/DefaultJMSProvider
[JMSProviderLoader] Started
[ServerSessionPoolLoader] Starting
[ServerSessionPoolLoader] JMS provider Adapter StdJMSPool bound to
java:/StdJMSPool
[ServerSessionPoolLoader] Started
[J2eeDeployer] Starting
[J2EE Deployer Default] Cleaning up deployment directory
[J2eeDeployer] Started
[RARDeployer] Starting
[RARDeployer] Started
[ConnectionManagerFactoryLoader] Starting
[MinervaNoTransCMFactory] Connection manager factory
'MinervaNoTransCMFactory bound to 'java:/MinervaNoTransCMFactory'
[ConnectionManagerFactoryLoader] Started
[ConnectionManagerFactoryLoader] Starting
[MinervaSharedLocalCMFactory] Connection manager factory
'MinervaSharedLocalCMFactory bound to 'java:/MinervaSharedLocalCMFactory'
[ConnectionManagerFactoryLoader] Started
[ConnectionManagerFactoryLoader] Starting
[MinervaXACMFactory] Connection manager factory 'MinervaXACMFactory bound to
'java:/MinervaXACMFactory'
[ConnectionManagerFactoryLoader] Started
[ConnectionFactoryLoader] Starting
[ConnectionFactoryLoader] Started
[ConnectionFactoryLoader] Starting
[ConnectionFactoryLoader] Started
[AutoDeployer] Starting
[AutoDeployer] Watching /u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy
[AutoDeployer] Watching /u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib
[AutoDeployer] Auto deploy of
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/tomcat-test.ear
[J2EE Deployer Default] Deploy J2EE application:
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/tomcat-test.ear
[J2EE Deployer Default] Create application tomcat-test.ear
[J2EE Deployer Default] inflate and install module tomcat-test.war
[J2EE Deployer Default] install module tomcat-test.jar
[J2EE Deployer Default] add all ejb jar files to the common classpath
[Container factory]
Deploying:file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/t
omcat-test.ear
[Verifier] Verifying
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/tomcat-test
.ear/ejb1002.jar
[Container factory] Deploying Optimized
[Container factory] Deploying NonOptimized
[ContainerManagement] Initializing
[ContainerManagement] Initialized
[ContainerManagement] Starting
[ContainerManagement] Started
[ContainerManagement] Initializing
[ContainerManagement] Initialized
[ContainerManagement] Starting
[ContainerManagement] Started
[Default] Added ClassLoader: org.jboss.web.WebClassLoader@c3679 URL:
http://cassia:8083/WebClassLoader@800377/
[Container factory] Deployed application:
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/tomcat-test
.ear
[J2EE Deployer Default] Starting module tomcat-test.war
[EmbeddedTomcatSX] deploy, ctxPath=/jboss,
warUrl=file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/tomc
at-test.ear/web1001/
[J2EE Deployer Default] J2EE application:
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/tomcat-test.ear is
deployed.
[AutoDeployer] Auto deploy of
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/acais-1.0.ear
[J2EE Deployer Default] Deploy J2EE application:
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/acais-1.0.ear
[J2EE Deployer Default] Create application acais-1.0.ear
[J2EE Deployer Default] inflate and install module acais-web.war
[J2EE Deployer Default] install module acais-ejb.jar
[J2EE Deployer Default] add all ejb jar files to the common classpath
[Container factory]
Deploying:file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/a
cais-1.0.ear
[Verifier] Verifying
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/acais-1.0.e
ar/ejb1004.jar
[Container factory] Deploying Account
[Container factory] Deploying DBaseListMaps
[Default] null
[Container factory] No resource manager found for jms/managerQueue
[Container factory] No resource manager found for jms/QueueConnectionFactory
[Default] null
[Bean Cache] Cache policy scheduler started
[ContainerManagement] Initializing
[ContainerManagement] Initialized
[ContainerManagement] Starting
[ContainerManagement] Started
[ContainerManagement] Initializing
[ContainerManagement] Initialized
[ContainerManagement] Starting
[ContainerManagement] Started
[ContainerManagement] Initializing
[ContainerManagement] Initialized
[ContainerManagement] Starting
[ContainerManagement] Started
[ContainerManagement] Initializing
[ContainerManagement] Initialized
[ContainerManagement] Starting
[ContainerManagement] Started
[ContainerManagement] Initializing
[ContainerManagement] Initialized
[ContainerManagement] Starting
[ContainerManagement] Started
[ContainerManagement] Initializing
[ContainerManagement] Initialized
[ContainerManagement] Starting
[ContainerManagement] Started
[Default] Added ClassLoader: org.jboss.web.WebClassLoader@52c6b4 URL:
http://cassia:8083/WebClassLoader@5424820/
[Container factory] Deployed application:
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/acais-1.0.e
ar
[J2EE Deployer Default] Starting module acais-web.war
[EmbeddedTomcatSX] deploy, ctxPath=/acais,
warUrl=file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/acai
s-1.0.ear/web1003/
[J2EE Deployer Default] J2EE application:
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/acais-1.0.ear is
deployed.
[AutoDeployer] Auto deploy of
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib/jms-ra.rar
[RARDeployer] Attempting to deploy RAR at
'file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib/jms-ra.rar'
[JmsXA] Using default value 'java:DefaultJMSProvider' for config property
'JmsProviderAdapterJNDI'
[JmsXA] FINE: Setting LogWriter: org.jboss.logging.LogWriter@406258
[JmsXA] Bound connection factory for resource adapter 'JMS Adapter' to JNDI
name 'java:/JmsXA'
[AutoDeployer] Auto deploy of
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib/jbosspool-jdbc.rar
[RARDeployer] Attempting to deploy RAR at
'file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib/jbosspool-jdbc.rar
'
[RARDeployer] Loading Minerva Resource Adapter for JDBC 1/2 drivers
[RARDeployer] Required license terms present. See deployment descriptor.
[MinervaDS] Not setting config property 'Driver'
[MinervaDS] Not setting config property 'Password'
[MinervaDS] Not setting config property 'UserName'
[MinervaDS] Bound connection factory for resource adapter 'Minerva JDBC
LocalTransaction ResourceAdapter' to JNDI name 'java:/MinervaDS'
[AutoDeployer] Started
[JMXAdaptorService] Starting
[JMXAdaptorService] Started
[RMIConnectorService] Starting
[RMIConnectorService] Started
[MailService] Starting
[MailService] Mail Service 'Mail' bound to java:/Mail
[MailService] Started
[Service Control] Started 27 services
[Default] JBoss 2.4 BETA(Rel_2_4_0_6) Started in 0m:35s

--- ~/jboss/conf/tomcat/jboss.jcml (JDBC section) ----------------
  <!--
==================================================================== -->
  <!--
     -->
  <!--
==================================================================== -->

  <mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
     <attribute name="Drivers">org.postgresql.Driver</attribute>
  </mbean>

  <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=DefaultDS">
    <attribute name="PoolName">DefaultDS</attribute>
    <attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
    <attribute name="Properties"></attribute>
    <attribute name="URL">jdbc:postgresql:acais://localhost:5432</attribute>
    <attribute name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser">MyUser</attribute>
    <attribute name="MaxSize">10</attribute>
    <attribute name="Password">MyPasswd</attribute>
    <attribute name="GCEnabled">false</attribute>
    <attribute name="InvalidateOnError">false</attribute>
    <attribute name="TimestampUsed">false</attribute>
    <attribute name="Blocking">true</attribute>
    <attribute name="GCInterval">120000</attribute>
    <attribute name="IdleTimeout">1800000</attribute>
    <attribute name="IdleTimeoutEnabled">false</attribute>
    <attribute name="LoggingEnabled">false</attribute>
    <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
    <attribute name="MinSize">0</attribute>
  </mbean>
  <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=PostgresqlDB">
    <attribute name="PoolName">PostgresqlDB</attribute>
    <attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
    <attribute name="Properties"></attribute>
    <attribute name="URL">jdbc:postgresql:acais://localhost:5432</attribute>
    <attribute name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser">MyUser</attribute>
    <attribute name="MaxSize">10</attribute>
    <attribute name="Password">MyPasswd</attribute>
    <attribute name="GCEnabled">false</attribute>
    <attribute name="InvalidateOnError">false</attribute>
    <attribute name="TimestampUsed">false</attribute>
    <attribute name="Blocking">true</attribute>
    <attribute name="GCInterval">120000</attribute>
    <attribute name="IdleTimeout">1800000</attribute>
    <attribute name="IdleTimeoutEnabled">false</attribute>
    <attribute name="LoggingEnabled">false</attribute>
    <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
    <attribute name="MinSize">0</attribute>
  </mbean>




_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to