Hi,
I am writing this while waiting for my data-request to finish. This is
in Base 3.0 on Aqua (Leopard/MacBook 2G RAM), serving as a frontend to
Postgres 8.35 with JDBC. I have a rather big table, about 220.000 rows
with about 25 colums. While the structure is big (for what I am used
to anyways :)) the data contained is very small, 2-3rds of the colums
are booleans, the rest are just integers or a few letters. If I do a
query on this table it takes a while, no prob, if I compare to
performance on PGMyadmin, not much difference. But - if once I
retrieve my resultset want to jump from the first to the last record,
it takes *aaages*. While a query might take 30 seconds, jumping from
first to last record might take 30 minutes. This is not the case with
pgmyadmin, where the jump is almost instant.
Is that a known problem, is there a workaround, is it a bug?
Best
Rainer
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
