From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-0.3 required=5.0 tests=BAYES_00,
	REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!mx02.eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Newsgroups: comp.lang.ada
Subject: Re: Compiling GNATColl on Windows
Date: Tue, 16 Dec 2014 11:10:53 +0100
Organization: cbb software GmbH
Message-ID: <1bkd0huwbs9ok$.158823hior2e7.dlg@40tude.net>
References: <09729271-32e5-4d7e-999f-2299a9c975fd@googlegroups.com>
 <27f6331d-31d4-4626-9b41-327c49bcbb6e@googlegroups.com>
 <5988fe56-ed84-4a6b-b5dd-d453b3c3b2f6@googlegroups.com>
 <8e88a5bd-30ab-4a23-974f-6fbeff11fb8c@googlegroups.com>
 <9a7fe568-2d34-42be-b1be-ce0653af005b@googlegroups.com>
 <m6nl8c$25m$1@dont-email.me> <1ifoukt5d2s2z$.6d9y7y2fiufo$.dlg@40tude.net>
 <m6orjs$h7n$1@dont-email.me>
Reply-To: mailbox@dmitry-kazakov.de
NNTP-Posting-Host: YGNMlxhiQ90vAyH0QA4qPw.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: 40tude_Dialog/2.0.15.1
X-Notice: Filtered by postfilter v. 0.8.2
Xref: news.eternal-september.org comp.lang.ada:24040
Date: 2014-12-16T11:10:53+01:00
List-Id: <comp.lang.ada>

On Tue, 16 Dec 2014 09:48:16 +0100, Björn Lundin wrote:

> But the table grows, and I expect it to be ca 33 M rows at the ens of
> the year. And next year, if I record the whole year, I'll end up with
> 60M+ rows.

But you could use the time stamp in the SELECT's WHEN? 

> For that, I _really_ like cursors on the server side.
> It seems like your ODBC reads the whole recordset into the clients memory?

No idea. It probably depends on the driver.

I never used ODBC to its end, because it would defeat the purpose of
keeping it RDBMS-agnostic. The cases where I used DB I tired to use the
most basic set of the features.
 
> Or do I misunderstand it?

The greatest problem of ODBC is that it practically does not mandate
anything. So you must question the capabilities of the actual driver and
then adapt your application to what is available. For an Ada programmers it
is the world turned upside-down, and a patented nightmare to write a
minimally robust and maintainable application.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de