From: Kovacs Baldvin <kb136@hszk.bme.hu>
To: pgsql-interfaces@postgresql.org
Subject: Q on JDBC's resultset
Date: Thu, 1 Feb 2001 21:39:51 +0100 (MET)
Message-ID: <Pine.GSO.4.21.0102012132230.9884-100000@ural2> (raw)
Hello.
I looked in the source and have the feeling that if I
execute a SELECT statement, the whole resultset comes through
the network in one large bundle.
Is it true?
It means that I cannot enable to use simple tablemodel and
table on top of an sql query, since it would be too slow to
download all of the data when opening it.
Anyway, how does the backend handles this? If I execute a query,
it copies the result immediately to a separate place?? So for
a SELECT *... query on a 2GB table results immediately in the
occupance of an pther two gigs?
Lastly, does anyone plans to work on updatable cursors? I think
that would make possibel to create read/write tablemodels in
Java.
Thanks,
Baldvin
p.s.: Does anyone knows if mysql supports updatable queries and
complete jdbc?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: kb136@hszk.bme.hu
Subject: Re: Q on JDBC's resultset
In-Reply-To: <Pine.GSO.4.21.0102012132230.9884-100000@ural2>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox