Subject Re: [firebird-support] Re: Queries done through ISQL must faster than in production
Author Mark Rotteveel
> The version of Firebird is 2.1.2. The application environment is Java
> under Tomcat w/Jaybird 2.1.6 JDBC driver. The server has 6Gig of memory with
> dual processors. Both ISQL and the Jaybird connections are done through
> localhost. The database size is about 23gig, page size is 4k.

By default JDBC drivers fetch a lot of rows into the resultset which 1) takes more memory and 2) takes more time. Have you tried setting the fetchsize of the JDBC statement to a small number (eg 10).
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter