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 ?
Thanks,
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);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
