Re: One more: rowcounts with DODS standalone!

Hi,



Now, in DODS we have three cache implementations:

DataStruct cache (list of DataStructs which represents rows in table),
simple and complex Query caches (list of oids as a result of SELECT
statements).  Also transaction cache....

Currently selectCount() method doesn't cache the results. DODS adds to cache
results of SQL statements, which are executed using runQuery() method.



Sinisa Milosevic,

Together Serbia







----- Original Message -----
From: "Axel Wilhelm Berle" <axelberle@xxxxxxxx>
To: <enhydra@xxxxxxxxxxx>
Cc: <A.Madl@xxxxxxxxxxx>
Sent: Wednesday, December 17, 2003 1:07 PM
Subject: Enhydra: One more: rowcounts with DODS standalone!


> Thanks Alfred,
>
> That was exactly what I needed! By accident I stumbled
> over the selectCount() method which seems to be the
> solution to another problem we are facing: how to
> count the number of rows of a query!
>
> My question is: does selectCount() cache the results?
> Or is it recalculated all the times it is called?
>
>
> Thanks in advance!
>
> Axel
>
>
>
>
>
>
> Subject: AW: Enhydra:  Browsing of tables with DODS
> Date: Tue, 16 Dec 2003 22:26:01 +0100
> From: "Madl Alfred" <A.Madl@xxxxxxxxxxx>
> To: <enhydra@xxxxxxxxxxx>
> Reply-To: enhydra@xxxxxxxxxxx
>
> Hi !
>
> xxxQuery classes support "readSkip" and
> "setDatabaseLimit" methods to
> do
> that ! "databaseLimitExceeded" even tells you, if
> there would be more
> data following...
>
> Greetings.
>
> Alfred
>
> -----Urspr=FCngliche Nachricht-----
> Von: Axel Wilhelm Berle [mailto:axelberle@xxxxxxxx]=20
> Bereitgestellt: Dienstag, 16. Dezember 2003 15:03
> Bereitgestellt in: Enhydra
> Unterhaltung: Enhydra: Browsing of tables with DODS
> Betreff: Enhydra: Browsing of tables with DODS
>
>
> Hi!
>
> I have a practical question concerning browsing of
> tables with DODS (standalone). I need to retrieve the
> contents of a table in pages. In the old version of
> DODS I constructed manually a query using the SQL
> OFFSET and LIMIT feature.
>
> What would be the best DODS way to browse a table,
> page for page, without the need to get the entire
> table at once and throw away the unneeded parts?
>
> Thanks in advance,
>
>    Axel
>
>
> Axel Wilhelm Berle
>
> e-mail: axelberle@xxxxxxxx
> Tel: (office) +55 16 618.0090
>      (mobile) +55 16 9964.6343
>
>
>
> =====
> Axel Wilhelm Berle
>
> e-mail: axelberle@xxxxxxxx
> Tel: (office) +55 16 618.0090
>      (mobile) +55 16 9964.6343
>
> __________________________________________________________________
>
> Gesendet von Yahoo! Mail - http://mail.yahoo.de
> Logos und Klingeltöne fürs Handy bei http://sms.yahoo.de
> _______________________________________________
> Enhydra mailing list
> Enhydra@xxxxxxxxxxx
> http://www.enhydra.org/mailman/listinfo.cgi/enhydra
>