Re: True DB Grid 5.0 Pro and Oracle Objects for OLE, #2

Does the user need to be able to scroll the grid back to see older records, or are you only interested in the most recent "screenful"? If it's the latter, you could modify your query to something like the following:

SELECT (columns)
FROM MEASURES
WHERE TIMESTAMP >=
      ((SELECT MAX(TIMESTAMP) FROM MEASURES) - 1/24) This would return the last hour's measurements.

Ing. Martin Gamperl wrote:
>
> Hi;
>
> We are using True DBGrid 5.0 to display measured data in "real time".
> Each minute a external process on a different computer adds over 500 new
>
> values (columns) in one record to the appropriate Oracle table. The
> table contains about 80,000 records (values for 2 month) and the grid
> control is used as a view to all the records whilst the number of
> columns is restricted to 10. To populate the grid control, it's used in
> bound mode using Oracle data control v2.1.
> After adding one new record with the aquisition process the
> visualisation application receives a message to update the grid control.
>
> Using the refresh/rebind methods of the data control / grid performance
> decreases dramatically.
> So does anyone know what we should do to fetch only the finally added
> record and refresh the grid display.
> We are using VB 5.0 (SP3)...
>
> Please reply by Email!
>
> Thanxs in advance
>
> Martin
>
> ---------------------------------------------------
> * Ing. Martin Gamperl
> * MGS Softwareentwicklung
> * Klosterwiesgasse 31/IV
> * A-8010 GRAZ
> * Tel. : +43-316-83 58 26
> * Fax : +43-316-83 58 26
> * Mobil : +43-664-40 03 032
> * EMail : mgampi_at_ibm.net
> ---------------------------------------------------
Received on Tue Feb 17 1998 - 00:00:00 CST