Where should I use proxy??
Thanks
<!-- Definitions for com..data.NotaRecibo -->
<class-descriptor
class="com..data.NotaRecibo"
table="notasrecibos"
>
<field-descriptor
name="id"
column="id"
jdbc-type="BIGINT"
primarykey="true"
autoincrement="true"
/>
<field-descriptor
name="id_prestador"
column="prestador"
jdbc-type="BIGINT"
/>
<reference-descriptor
name="prestador"
class-ref="com..data.Prestador"
>
<foreignkey field-ref="id_prestador"/>
</reference-descriptor>
<field-descriptor
name="id_servico"
column="servico"
jdbc-type="BIGINT"
/>
<reference-descriptor
name="servico"
class-ref="com..data.ServicoJuridico"
>
<foreignkey field-ref="id_servico"/>
</reference-descriptor>
<field-descriptor
name="data"
column="DATA"
jdbc-type="DATE"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi
eldConversion"
/>
<field-descriptor
name="pagamento"
column="PAGAMENTO"
jdbc-type="DATE"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi
eldConversion"
/>
<field-descriptor
name="credito"
column="CREDITO"
jdbc-type="DATE"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFi
eldConversion"
/>
<field-descriptor
name="valor"
column="VALOR"
jdbc-type="DOUBLE"
/>
<field-descriptor
name="retidoIRRF"
column="RETIDOIRRF"
jdbc-type="DOUBLE"
/>
<field-descriptor
name="retidoINSS"
column="RETIDOINSS"
jdbc-type="DOUBLE"
/>
<field-descriptor
name="retidoISS"
column="RETIDOISS"
jdbc-type="DOUBLE"
/>
<field-descriptor
name="outros"
column="OUTROS"
jdbc-type="DOUBLE"
/>
<field-descriptor
name="numeroNF"
column="NUMERONF"
jdbc-type="BIGINT"
/>
<field-descriptor
name="recibo"
column="RECIBO"
jdbc-type="BIGINT"
/>
<field-descriptor
name="id_darf"
column="DARF"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="darf"
class-ref="com..data.Darf"
>
<foreignkey field-ref="id_darf"/>
</reference-descriptor>
<field-descriptor
name="gps"
column="GPS"
jdbc-type="INTEGER"
/>
<field-descriptor
name="iss"
column="ISS"
jdbc-type="INTEGER"
/>
<field-descriptor
name="id_empresa"
column="id_empresa"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="empresa"
class-ref="com..data.Empresa"
>
<foreignkey field-ref="id_empresa"/>
</reference-descriptor>
<field-descriptor
name="exportado"
column="EXPORTADO"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="excessoes"
element-class-ref="com..data.NotaRecibo_Excessao"
auto-retrieve="true"
auto-update="true"
auto-delete="true"
refresh="true"
>
<inverse-foreignkey field-ref="id_notaRecibo"/>
</collection-descriptor>
</class-descriptor>
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 01, 2003 9:57 AM
Subject: RE: too slow!
> Hello Andrade,
>
> > -----Original Message-----
> > From: Glauber Andrade [mailto:[EMAIL PROTECTED]
>
> > I am using OJB and Mysql (4.0.16) (with
> > mysql-connector-java-3.0.9-stable)
> > in an swing application and the system is too slow. A simple
> > query whith
> > 2000 registers takes more than 15s to go.
> > How can I speed it up ?
>
> You have to give us some more information, for example
> your repository_user.xml.
>
> Besides, you may have a look at the documentation
> (proxies etc.)
>
> > Criteria crit = new Criteria();
> > crit.addEqualTo("id_empresa", "" + empresa.getId());
> > crit.addOrderBy("pagamento", true);
> > crit.addOrderBy("prestador.nome", true);
> > Query q = QueryFactory.newQuery(NotaRecibo.class, crit);
> > Collection c = broker.getCollectionByQuery(q);
>
> Olli
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
