| Subject | Re: [firebird-support] Re: Queries done through ISQL must faster than in production |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2010-02-07T09:45:34Z |
> The version of Firebird is 2.1.2. The application environment is JavaBy 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).
> 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.
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01