Hi Everyone,
as I mentioned earlier, we use Sequoia with an Oracle-DB as a
single-db-backend.
Our controller needs over 30min to start. What could be the reason? Is
this normal?
We have a second DB (Informix) where it starts much faster, same config.
Please see xml-Config below.
Please can You answer if you know anything, we want to use our
configuration in real life.
Thanx in Advance.
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.3//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.3.dtd";>
<SEQUOIA>
<VirtualDatabase name="loga_vDB" maxNbOfConnections="100"
poolThreads="true" minNbOfThreads="0" maxNbOfThreads="100"
maxThreadIdleTime="60" sqlDumpLength="40">
<AuthenticationManager>
<Admin>
<User username="aduser" password="xyz"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="apuser" vPassword="xyz"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="logaNode"
driver="oracle.jdbc.driver.OracleDriver" url="xyz"
connectionTestStatement="SELECT * FROM dual">
<DatabaseSchema dynamicPrecision="all"
gatherSystemTables="false"/>
<ConnectionManager vLogin="apuser" rLogin="xyz" rPassword="xyz">
<SimpleConnectionManager/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager caseSensitiveParsing="false" beginTimeout="60"
commitTimeout="60" rollbackTimeout="60">
<RequestScheduler>
<SingleDBScheduler level="pessimisticTransaction"/>
</RequestScheduler>
<RequestCache>
<MetadataCache maxNbOfMetadata="1000" maxNbOfField="100"/>
<ParsingCache backgroundParsing="false" maxNbOfEntries="500"/>
</RequestCache>
<LoadBalancer transactionIsolation="databaseDefault">
<SingleDB/>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Greetings
Sebastian Zickau
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
