Skip site navigation (1) Skip section navigation (2)

Re: Limit vs setMaxRows issue

From: Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Limit vs setMaxRows issue
Date: 2006-07-10 08:59:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Mark Lewis <mark(dot)lewis(at)mir3(dot)com> writes:

> JDBC is a little too low-level to give true database independence; you
> can write portable queries, but you're severely restricted when it comes
> to functionality supported by most databases but not in a standardized
> way, such as limits, locking, performance hinting, sequences/serials,
> etc.
> For simple, non-performance critical apps you can mostly get away with
> it (as we did for a while with some of our products).  But for anything
> more sophisticated, your application really needs a way to deal with
> database-specific SQL.

Thanks a lot for sharing this very valuable experience from the
field. However .setMaxRows() IS currently part of this portable and
severely restricted JDBC performance feature set, so I see no reason
for not trying to implement it as best as possible.

The more performance you can get from JDBC, the less not portable code
people will write.

And JDBC is evolving too.

In response to

pgsql-jdbc by date

Next:From: Marc HerbertDate: 2006-07-10 09:06:15
Subject: Re: Limit vs setMaxRows issue
Previous:From: Marc HerbertDate: 2006-07-10 08:51:21
Subject: Re: Limit vs setMaxRows issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group