I have a database that contains three tables :
- arch : 20000 records
- epic : 10000 records
- arch_epic : 30000 records that are links between my two tables ARCH
and EPIC...
When i make a simple request using JDO such as �Select e From EPIC e",
it take 28s to jdo for reading the first record...
What can i do ???
thanks
CHAMAGNE Jean-Christophe
Strasbourg Astronomical Observatory
This my mapping file :
<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor Mapping DTD Version
1.0//EN"
"http://castor.exolab.org/mapping.dtd";>
<mapping>
<class name="EPIC" identity="id">
<description>EPIC</description>
<map-to table="epic"/>
<field name="id" type="integer" >
<sql name="_id" type="integer"/>
</field>
<field name="RA" type="double" >
<sql name="_ra" type="double"/>
</field>
<field name="DEC" type="double">
<sql name="_dec" type="double"/>
</field>
<field name="arch" type="ARCH" required="true" collection="vector">
<sql name="_arch_id" many-table="arch_epic" many-key="_epic_id"/>
</field>
</class>
<class name="ARCH" identity="id">
<description>ARCH</description>
<map-to table="arch"/>
<field name="id" type="integer" >
<sql name="_id" type="integer"/>
</field>
<field name="RA" type="double" >
<sql name="_ra" type="double"/>
</field>
<field name="DEC" type="double">
<sql name="_dec" type="double"/>
</field>
<field name="catalogue" type="java.lang.String">
<sql name="_catalogue" type="char"/>
</field>
<field name="epic" type="EPIC" required="true" collection="vector">
<sql name="_epic_id" many-table="arch_epic" many-key="_arch_id"/>
</field>
</class>
</mapping>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
