Excellent! Jason comes thru again.

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> Using the Unidirectional property (which should also be on the
TIBOQuery
> component) should be just fine. You will need to use this if you
are going
> to make use of 3rd party components which expect you to work via a
TDataset
> based component. It will only be slightly slower than the TIB_Cursor
> component and it will carry a little bit larger memory footprint,
but not
> enough to worry about I don't think.
>
> A common thing people do is use the AssignSQLWithSearch( ) method
so that
> they can allow people to use the nice search mode feature of the
TIB_
> components and then be able to easily run a report through the same
dataset
> via a TIBOQuery component (which is TDataset based).
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <tashi@f...>
> To: <IBObjects@y...>
> Sent: Wednesday, November 07, 2001 1:55 PM
> Subject: Re: [IBO] Component Compatibility
>
>
> > This part of the application typically several hundred records but
> > can get upwards of 20 - 25 thousand. Another part of the
application
> > not yet complete can get to 600,000+ records.
> >
> > For those of you whom may think I've flipped as to why I would do
an
> > application that would allow that many records to be retrieved,
let
> > me explain.
> >
> > This application is for the Financial Data for all the Community
> > Colleges in Illinois. Chief Financial Officers of the colleges
want
> > to query the database for multiple colleges information and save
that
> > data on their own systems (Database, Spreadsheets, etc.) for their
> > own analysis and studies.
> >
> > Although the application does have standard Financial Reports, I
have
> > been tasked to give them the ability to retrieve any inforamtion
they
> > want, no matter how much, in whatever format they need to work on
> > their own systems.
> >
> > Later applications will be built accessing millions of records
> > (Student Records, with 1 million+ added every year). In reading
the
> > Which component should I use in the IBO Help file. I gather I
should
> > use the (IB_) components wherever I can, one for functionality,
two
> > for speed. Which is what I'm looking for in all my Applications.
> >
> > The help file also states that in the unidirectional for IB_Query
> > (there was no unidirectional help for IBOQuery) "if possible, to
use
> > the TIB_Cursor component and thus avoid the overhead of the
buffering
> > layer.", will this ba a major issue for me later with the large
> > amounts of data?
> >
> > Thanks again
> > Kevin