large queries


Hi,

Can anyone make a recommendation on how
to design a Java system that will make SQL
queries on a mySQL database that results in very
large data sets? What can be done to improve
performance? Is hybernate better than using
straight JDBC?


Thanks,

Terry
.

Relevant Pages

  • Re: large queries
    ... to design a Java system that will make SQL ... queries on a mySQL database that results in very ... Can you partition your queries? ...
    (comp.lang.java.databases)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)
  • Re: Dynamic query problem
    ... On Oct 17, 9:41 am, Andy Hull ... If we were to provide a fully featured dynamic query generator we would have ... Provided with already built queries which they can edit ... SQL and see where it is the same as for the other queries and where it ...
    (microsoft.public.access.queries)
  • Re: SSMA - Query Conversion to Stored Procedures.
    ... I'm wondering if you're running into the same bug that hits the older SQL ... As for the parameterized queries, ... You want to use SSMA to migrate your Access database to SQL Server 2005 ... But when I load those conversions to database, ...
    (microsoft.public.access.adp.sqlserver)