Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: True DB Grid 5.0 Pro and Oracle Objects for OLE, #2
The user should be able to see all the records. That's why we have performance problems...
Kevin P. Fleming schrieb:
> 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
> > ---------------------------------------------------
-- --------------------------------------------------- * 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